Oracle flashback drop knowledge sorting

Oracle flashback drop knowledge sorting 1) No downtime or backup is required. 2) You do not need to configure it. you can disable it through permissions. 3) Only data in non-SYSTEM tablespace managed locally (non-dictionary management) will enter the recycle bin. You can also use flashback drop 4) the DROP command can only be used for tables. You can view the DROP table in the recycle bin ([SQL] SQL> show recyclebin; // view ). The data cannot be flashed back to TRUNCATE, and the data cannot be flashed back to the PURGE table. 5) You cannot return physical errors. You can only return logical errors caused by user errors. 6) The success cannot be guaranteed. The earlier the deletion, the more likely the FLASHBACK will be. 7) indexes, triggers, authorization, unique constraints, and non-null constraints are also flashed back. However, foreign key constraints cannot be restored. Because the foreign key is not renamed, it is actually deleted. If table A contains an index, trigger, or constraint on I, if I is deleted first, then A is deleted, when falshback drop A, the index, trigger, or constraint will not be restored. 8) tables that use drop user xxx cascade cannot flash back through flashback drop.

[SQL] SQL> select * from knight. books; // initial status id name price ------------------ ---------- 200 WEBWORK 299.9 201 PMP 56.99 1 STRUTS2 199 300 DB2 299 2 AIX 50.5 3 NETWORK 125.89 4 JAVA 88.99 5 JQUERY 102.988 rowsselected. [SQL] SQL> drop table knight. books; // Delete Table dropped. [SQL] SQL> select * from knight. books; // select * from knight. books * ERROR at line1: ORA-00942: table or view does not exist [SQL] SQL> flashback table knight. books to before drop rename to newbooks; // start flashing back and rename Flashback complete. [SQL] SQL> select * from knight. books; // the old name cannot find select * from knight. books * ERROR at line1: ORA-00942: table or view does not exist [SQL] SQL> select * from knight. newbooks; // check the idname price ------------------ ---------- 200 WEBWORK 299.9 201 PMP 56.99 1 STRUTS2 199 300 DB2 299 2 AIX 50.5 3 NETWORK 125.89 4 JAVA 88.99 5 JQUERY 102.988 rows selected. [SQL] SQL> drop table knight. newbooks purge; // use PURGE Table dropped. [SQL] SQL> flashback table knight. newbooks to before drop rename to secondbooks; // The flashback table knight cannot be flashed back. newbooks to before drop rename to secondbooks * ERROR at line1: ORA-38305: object not in RECYCLE BIN

 

(End)