Tool to use in order to copy schemas
Hi,
Assuming I have two 11g databases on two separates Windows servers.
I need to replace schemas on target database by schemas on source database.
Here are my constraints :
1) I need an automatic tool (no need to perform manual actions).
2) My schemas contain long type data (not possible to use impdp with a network link)
3) I want to run my tool from a server that's not one of the two servers hosting databases
4) I don't have the create users script
For the moment, I found these two solutions :
Using sql developer (copy database tool)
Using oem cc 12c, but the copy schema tool doesn't work (Oracle support told me it works on 13c)