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.