Home > IT Answers > Oracle > Flashback query
Mayleong
0 pts.
 Flashback query
Oracle
Background: Oracle 9.2.0 running on win2003 I have enabled UNTO_RETENTION = 36000 (10 hours). I executed the dbms package using userid = SYSTEM EXECUTE DBMS_FLASHBACK.ENABLE_AT_TIME(SYSDATE - 10/24); I got the error message "SYS.DBMS_FLASHBACK not enabled for user sys" Why is Oracle giving me this error msg when i execute the dbms package under userid SYSTEM not SYS?

Software/Hardware used:
ASKED: August 21, 2005  10:43 PM
UPDATED: August 22, 2005  10:53 AM
RELATED QUESTIONS
Answer Wiki:
Follow the instructions in 'Application Developer's Guide - Fundamentals', which suggest giving execute privileges on the package to particular users.
Last Wiki Answer Submitted:  August 22, 2005  10:53 am  by  Structsound   0 pts.
All Answer Wiki Contributors:  Structsound   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _