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!

Remap tables to different tablespaces using impdp

User_QKSJCMar 21 2017 — edited Mar 21 2017

Hi,

is is possible to remap tables to different tablespaces using impdp in a single run.

My database is oracle12c EE.

for example i have 10(say t1, t2 .....t10) tables in source database all in "users" tablespace exported using expdp and importing using impdp in different database, can i import tables t1,t2 to TB1, t3,t4 to TB2 and so on...

(TB here is Tablespace)

Please let me know if it is possible.

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2017

Added on Mar 21 2017

#database-key-features, #export-import-sql-loader-external-tables

6 comments

2,443 views