Skip to Main Content
Forums

Oracle Database Discussions

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!

copy one user data to multiple users

km1612Mar 27 2012 — edited Mar 27 2012
Hi All,
We have a requirement to copy tables without data from
ABC to ABC1, ABC2, ABC3
XYZ to XYZ1, XYZ2, XYZ3

I am planning to achieve this as below.

expdp system@db10g directory=TEST_DIR dumpfile=expdp_db10g.dmp schemas=ABC,XYZ logfile=expdp_db10g.log CONTENT=METADATA_ONLY

impdp system@db10g directory=TEST_DIR dumpfile=expdp_db10g.dmp logfile=impdp_db10g.log REMAP_SCHEMA=ABC:ABC1 REMAP_SCHEMA=ABC:ABC2 REMAP_SCHEMA=ABC:ABC3 REMAP_SCHEMA=XYZ:XYZ1 REMAP_SCHEMA=XYZ:XYZ2 REMAP_SCHEMA=XYZ:XYZ3

Is above correct?
Is there any other better way to achieve this task?
My Oracle DB version is Oracle Database 10g Enterprise Edition Release 10.2.0.3.0.

Thanks for your help.

Regards
Kalai
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2012
Added on Mar 27 2012
#general-database-discussions
4 comments
240 views