Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALTER FLASHBACK ARCHIVE giving ORA-55611

spur230Aug 15 2016 — edited Aug 31 2016

I am using Oracle 12.1.0.2

I have created following flashback archive. I want to manage it using different user_1 .

select * from dba_flashback_archive;

       

OWNER_NAMEFLASHBACK_ARCHIVE_NAMEFLASHBACK_ARCHIVE#RETENTION_IN_DAYSCREATE_TIMELAST_PURGE_TIMESTATUS
SYSFDA_7DAY17 8/12/2016 5:54:49.000000000 PMDEFAULT

As sys,

I gave :

grant FLASHBACK ARCHIVE ADMINISTER  to user_1;

However,  as user_1, I am getting following error.

         ALTER FLASHBACK ARCHIVE fda_7day PURGE ALL;

         --ORA-55611: No privilege to manage default Flashback Archive

Anybody know what I am doing wrong?
This post has been answered by spur230 on Aug 31 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2016
Added on Aug 15 2016
#general-database-discussions
7 comments
1,556 views