3 Replies Latest reply: Jul 8, 2013 8:50 AM by Dean Gagne-Oracle RSS

    To capture all the objects from an tablespace and restore.


      Hi All,


      I have a situation in the  Schema  refresh process where i may have  to delete a tablespace  and its datafiles.


      Then I have to recreate it as it was before and restore all it objects .


      Is there any way that i can capture all the objects of that tablespace before it is deleted  and then later restore it back as it was .


      Any Expert sugggestion is highly apprciated .


      The Platform is as below ..


      Oracle Database 11g Enterprise Edition Release - 64bit Production

      PL/SQL Release - Production

      CORE      Production

      TNS for Linux: Version - Production

      NLSRTL Version - Production




      Thanks In Advance .