Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMPDP REMAP_TABLESPACE mutiple tablespace

2922227Jun 9 2015 — edited Jun 9 2015

Hi Guys,check with you all, a schema's tables reside in 2 tablespace, when i use impd remap_tablespace, can i put all tables into 1 tablesapce?

Example:

Souce DB

ABC (DB name) , TEST (schema users), table_1(tablespace TBA_A) , table_2(Tablespace TBA_B)

Target DB

CDE (DB name), TEST (Schema users). only have 1 tablespace (TBA_A)

is following command correct?

import system/XXXX schame =test remap_tablesapce(TBA_A:TBA_A, TBA_B, TBA_A)   <-- correct ?  or i dont need TBA_A:TBA_A


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2015
Added on Jun 9 2015
3 comments
3,533 views