Re: Table Drop -oracle 12c

Posted by ErmanArslansOracleBlog on Mar 27, 2019; 11:59am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Table-Drop-oracle-12c-tp7306p7312.html

1)Check recyclebin -> SHOW RECYCLEBIN;
Also you can check audit records.

2)restore your database from backup as an additional database (with a different name), recover this restored database according to your needs using archivelogs . Then export that table from that restored database and import it to your TEST database.
Alternatively, you can use the RECOVER TABLE command, which is a new feature in 12C that allows a point in time recovery of a table or a table partition.