Flashback Any Table - System Privilege.
Flashback privilege on that particular table.
Q) Can you flashback a table owned by another user.
A) Yes. But to do so you need select, insert, delete and alter privilege on the table as well as one of the above mentioned privilege.
Q) Can you flashback all types of tables
A) No. The flashback will not work for the following types of tables,
Advanced Queuing (AQ) tables
Individual table partitions or subpartitions
Materialized Views
Nested tables
Object tables
Remote tables
Static data dictionary tables
System tables
Tables that are part of a cluster
Thanks
Sunday, March 29, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment