12 Replies Latest reply on Jul 22, 2012 6:33 PM by EdStevens

    how to recover a dropped tablespace?

      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.