This discussion is archived
10 Replies Latest reply: Feb 7, 2013 5:31 AM by User286067 RSS

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

810723 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points