Table Drop -oracle 12c
Posted by satish on Mar 22, 2019; 5:56am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Table-Drop-oracle-12c-tp7306.html
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