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:
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?
1) When we use METADATA_ONLY for content:- Does it mean we are exporting all object definitions(DDL for table,index etc etc) in that SCHEMA except data or it means it is expoting metadata from SYS or SYSTEM schema?
The remap_tablespace should do the trick. All objects are hard coded to a tablespace so your situation is no different. The remap_tablespace should do exactly what you want it to do. You can see this by running the sqlfile option of import and then look at the tablespaces in the create statements.
One quick note on using sqlfile to create indexes. You don't need to do this. You can run your first impdp with: