This discussion is archived
14 Replies Latest reply: Jun 19, 2012 10:56 AM by Ahmer Mansoor RSS

solution drop table by mistake

941264 Newbie
Currently Being Moderated
oracle 9i release 1
the question is how can i get the exact time when the table is dropped?

solution for dropping a important table with flashback off
1.notify all the user to log off;
2.shutdown immediate;
3.startup restricted;
4.execute alter system switch logfile serveral times,
make sure all the online redo log files archived to the destination you specified by some parameters eg. log_archive_dest_n.
5.copy a full backup plus all the archived log to an other server installed oracle system.
6.ultilize this oralce instance startup the database just moved
7.start incomplete recovery steps using archived logs
8.recover to the dropped time
9.create a db link in the orginal database connecting to this server`s database
10.recreate the orginal dropped table and insert back from the target database

i figure out the above solution,but i don`t know if it will work effect.
even it works,how can i get the exact time when the table is dropped?

if a appication in coding doestn`t require 'drop table' previllege ,i will revoke it .
may i get better solutions ?

Edited by: 938261 on Jun 19, 2012 5:33 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points