CODEWITHSUNDEEP
oracle-databaseoracle10goracle11gdatabase-partitioning
jdamae
jdamae

Reputation: 3909

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

Upvotes: 0

Views: 3538

Answers (1)

Daniel Haviv
Daniel Haviv

Reputation: 1036

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

Upvotes: 2

Related Questions