This discussion is archived
12 Replies Latest reply: Jul 22, 2012 11:33 AM by EdStevens RSS

how to recover a dropped tablespace?

945465 Newbie
Currently Being Moderated
I am using oracle 10g and linux 4

accidentally I dropped a tablespace in with same name in 2 different databases (A , B)
A is archive log enabled
B is in no Archive mode.

now i want to recover the tablespace from the backup.

can it be done?
if so, how?

pls explain.

thanx in advnce.


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