Table Drop -oracle 12c

[satish]

Dear Erman,

1)what are the ways,we can get the exact time stamp at which a table is dropped.I am looking into alertlog but unable to find it.
2)In our test database,where the table is dropped,we dont have rman backups,no flashback,no recycle bin but database is in archivelog mode and we have all the archivelogs.In this case,can we recover the table with only the archivelogs available?

we are on 12.1.0.2

Thank you

[ErmanArslansOracleBlog]

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.

[Sri]

Dear erman,

Thanks for the update.
As updated,Recyclebin is off in our environment and as this is dev environment we don't have scheduled backups.Only thing,it is in archive log mode. In this case, can we get back the table.

Thank you

[ErmanArslansOracleBlog]

Normally, you should 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.

*But if you don't have any backups, you can't.