CODEWITHSUNDEEP
oracle-databaseresetflashback
user2073471
user2073471

Reputation: 41

Oracle flashback table reset

Is there a way in Oracle to check with a sql (pl/sql) statement if a table is reset by a user?

Upvotes: 1

Views: 258

Answers (1)

Justin Cave
Justin Cave

Reputation: 231681

There is nothing in the data dictionary that will tell you whether a FLASHBACK TABLE operation was ever performed on a table. The ROW_MOVEMENT column of DBA_TABLES (or ALL_TABLES or USER_TABLES depending on your requirements and privileges) will tell you whether row movement is currently enabled which would allow someone to do a FLASHBACK TABLE.

Upvotes: 1

Related Questions