12 Replies Latest reply: Jul 22, 2012 1:33 PM by EdStevens RSS

    how to recover a dropped tablespace?

    945465
      Hi
      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.