Search code examples
oracle-databaseoracle10goracle11gdatabase-partitioning

oracle - how to copy partitioned table to a new schema on new tablespace


I created a datapump export (Oracle 11g) from SCHEMA A on a partitioned table (tablespace TEST``) usingTABLE=MYPARTTBL:MYPART`.

I created a new schema SCHEMA B and imported the dump of SCHEMA A's partitioned table with success, but it created the table using the same tablespace TEST.

What I need to do is import the partitioned table to a different tablespace TEST_NEW.

What's a good way to do this? Considering now, that I have a copy of SCHEMA A's partitioned table in SCHEMA B.

Here's my export parfile parameters:

DIRECTORY=DW_PUMP
TABLES=MRA.FACT_USE:P_20111009
DUMPFILE=MRA.TBLPART-20111209.dmp
LOGFILE=MRA.TBLPART-20111209.log

Solution

  • Use the REMAP_TABLESPACE parameter when importing: REMAP_TABLESPACE=TEST:TEST_NEW