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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!