重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: Unable to Drop Restore Point Created with Special Character [打印本页]

作者: 刘泽宇 时间: 2025-8-16 18:48
标题: Unable to Drop Restore Point Created with Special Character
目标：
Not able to Drop A Restore Point Created with a Special Character

NAME TIME
------------------------------------------------------------ ---------------------------------------------------------------------------
CTASK1239507_MBRSTGP? 08-NOV-19 09.27.15.000000000 PM

处理方法：
Use the below command to find out the complete name of the Restore Point :

SQL> select ''''||name||'''',length(name) from v$restore_point;

''''||NAME||''''
--------------------------------------------------------------------------------
LENGTH(NAME)
------------
'CTASK1239507_MBRSTGP?'
21

Here we see '?' which is a special character but to find the special character run below steps:

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

open a new sqlplus

SQL>select name from v$restore_point;

NAME
--------------------------------------------------------------------------------
CTASK1239507_MBRSTGPï¿½

SQL> drop restore point "CTASK1239507_MBRSTGPï¿½";

Restore point dropped.

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)