Flashing back after oracle11gdroptable

Flashing back after oracle11gdroptable

-- Initialize the data drop table test purge; create table test as select * from dba_objects; delete from test where object_id is null; alter table test add constraint pk_test_object_id primary key (object_id ); create index ind_t_object_name on test (object_name); -- execute the delete operation drop table test; select r. object_name, r. original_name, r. operation, r. type from recyclebin r; OBJECT_NAME ORIGINAL_NAME operation type items ------------------ -------- BIN $ tables = $0 test drop tablebin $ tables = $0 PK_TEST_OBJECT_ID drop indexbin $ tables = $0 IND_T_OBJECT_NAME drop index -- generate a flashback table select 'flashback table' | r. original_name | 'to before drop; 'ccfrom recyclebin rwhere type = 'table'; CC -------------------------------------- flashback table test to before drop; -- the index will be flashed back, but the name will be changed to select 'alter index "'| r. object_name | '"rename to"' | r. original_name | '"; 'cccfrom recyclebin rwhere type = 'index'; CCC reset alter INDEX" BIN $ ffq1sqrmvjguaoklg9c7a = $0 "rename to" IND_T_OBJECT_NAME "; alter index "BIN $ FfQ1SQRnVJjgUAoKlg9C7A = $0" rename to "PK_TEST_OBJECT_ID"; finally run: flashback table TEST to before drop; alter index "BIN $ partition = $0" rename to "IND_T_OBJECT_NAME"; alter index "BIN $ ffq1sq1_vjjguaoklg9c7a = $0" rename to "PK_TEST_OBJECT_ID ";