James's Blog

Oracle: Flashback

-- flashback doesn't work on system tablespace.( don't login as sys/system)

- startup mount

- alter database archivelog;

- alter system set DB_FLASHBACK_RETENTION_TARGET=1440

- alter system set DB_RECOVER_FILE_SIZE=512000000

- alter database flashback on;

- alter database open

- flashback table "TEST" to before drop;

-- two important things: SCN and 'Recycle Bin'
show recyclebin;

posted by James Pei @ 9:45 AM