10 Replies Latest reply on Feb 7, 2013 1:31 PM by Raj Jamadagni

    EXPDP and IMPDP: Best process - re-organize tables and metadata in sep.tbsp

      Hi All,

      I am looking for the best approach to "Re-Org schema" by importing tables and indexes into two different 'tablespaces'. Like to know the best process to follow:

      Current Process:

      1) One schema 'abc' (DEV) to be expdp and impdp to other schema 'abc' in other database(PROD) but want them to be in a more 'oraganised' way? Like metada and all in one tablespace and tables in other? What will be the best approach to follow?

      Database: 11gR2 on UNIX


      Edited by: Junr DBA on Feb 6, 2013 7:56 AM