What would you do to recover the table?

You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode.
At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the
data dictionary was dropped at 03:00 p.m.
What would you do to recover the table?

You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode.
At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the
data dictionary was dropped at 03:00 p.m.
What would you do to recover the table?

A.
use the Flashback Transaction Query feature to identify the relevant SQL statement and use it
toundrop the table

B.
restore the entire database from the most recent backup and open it

C.
recover the table by using the Flashback Table feature

D.
perform point-in-time recovery to recover the table



Leave a Reply 0

Your email address will not be published. Required fields are marked *