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

    To capture all the objects from an tablespace and restore.

    User347578

      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 11.2.0.2.0 - 64bit Production

      PL/SQL Release 11.2.0.2.0 - Production

      CORE    11.2.0.2.0      Production

      TNS for Linux: Version 11.2.0.2.0 - Production

      NLSRTL Version 11.2.0.2.0 - Production

       

       

       

      Thanks In Advance .