Common Issue with Flashback (Part-5)
Error:ORA-01466: unable to read data – table definition has changed Solution:With Newell created table, we should wait for few minutes for the SCN to propagate…
Category: Flashback
Recycle Bin (Part-4)
A recycle bin contains all the dropped database objects and their dependent objects. Note: We can drop it immediately and permanently with purge option (DROP…
Monitoring flashback Database (Part-3)
How to eastimating size of Flash Recovery Area for Flashback Logs? SQL> SELECT ESTIMATED_FLASHBACK_SIZE FROM V$FLASHBACK_DATABASE_LOG; This Query will return an estimate disk space (needed)…
Flashback Recovery Case Study (Part-2)
Prerequisites for Flashback recovery: Must have FLASHBACK ANY TABLE system privilege or must have FLASHBACK object privilege on the table. Must have SELECT, INSERT, DELETE,…
Enable Flash Recovery Area / Flashback database (Part-1)
Flashback functionalities provide fast and flexible data recovery. Type of flashback recovery: Flashback Database (We can revert database at a past time) Flashback Drop (Reverses…