Sunday, March 29, 2009

Flashback Table - Privileges

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

No comments:

Followers

Powered By Blogger
 

Oracle Database Administration. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com