Oracle Error: PLS-00201 identifier 'dbms _ FLASHBA problem in the use of PL/SQL package dbms_flashback for flash back query, can not directly use 'sys 'user to call: 01SQL> exec dbms_flashback.enable_at_time (systimestamp-interval '15' minute); 02 03 BEGIN dbms_flashback.enable_at_time (systimestamp-interval '15' minute); END; 04 05*06 07 ERROR at line :08 www.2cto.com 09ORA-08185: Flashback not supported for user SYS10 11ORA-06512: at "SYS. DBMS_FLASHBACK ", line 312 13ORA-06512: at line 1
Switch to a common user who needs to perform a flash-back query, but authorization is required before that. If not authorized, the following error occurs: 01SQL> exec dbms_flashback.enable_at_time (paiimestamp-interval '15' minute); 02 03 BEGIN minute (paiimestamp-interval '15' minute); END; 04 05*06 07 ERROR at line www.2cto.com rows: line 1, column 11PLS-00201: identifier 'dbms _ FLASHBACK 'must be declared12 13ORA-06550: line 1, column 15PL/SQL: statement ignored authorization: 01SQL> conn/as sysdba02 03Connected. 04 05SQL> grant execute on dbms_flashback to scow.06 07 Grant succeeded.08 09SQL> conn scow./ scow.10 www.2cto.com 11Connected. 12 13SQL> exec dbms_flashback.enable_at_time (systimestamp-interval '15' minute); 14 15PL/SQL procedure successfully completed.16 17SQL>