10 Replies Latest reply: Feb 7, 2013 7:31 AM by User286067 RSS

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

    810723
      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

      Thanks,
      DBA_Guide

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