Skip to Main Content

Database Software

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!

Using FlashBack Query

EZGmsMay 20 2011 — edited May 20 2011
Hi,

I need to retrieve a previous version of a stored procedure using the next query
select TEXT from dba_source 
     as of timestamp systimestamp - interval '1' day
     where name='P_CLUB_ALERTS_DAILY' order by line;
and the output give me an error

ORA-01031: insuficient priviledges

my user has the FLASHBACK ANY TABLE PRIVILEGE

could anybody help me.

Thanks in advance...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2011
Added on May 20 2011
2 comments
244 views