impdp question to copy a user on a local instance
Hi,
Does anyone here know of a way that I can copy a local instance user to a new local instance user?
What I have so far that works requires a link as so;
impdp me/notyou network_link=local.db.com directory=data_pump_dir schemas=UTEST1 remap_schema=UTEST1:UTEST2 logfile=UTEST.log
and, continuing, before I spend time on it - how can I do the same with multiple users in one command (with or without link)? e.g remap_schema=USER1:USERA,USER2:USERB,USER3:USERC schemas=USER1,USER2,USER3
Thanks,
Randy
Does anyone here know of a way that I can copy a local instance user to a new local instance user?
What I have so far that works requires a link as so;
impdp me/notyou network_link=local.db.com directory=data_pump_dir schemas=UTEST1 remap_schema=UTEST1:UTEST2 logfile=UTEST.log
and, continuing, before I spend time on it - how can I do the same with multiple users in one command (with or without link)? e.g remap_schema=USER1:USERA,USER2:USERB,USER3:USERC schemas=USER1,USER2,USER3
Thanks,
Randy
0