Database Utilities (MOSC)

MOSC Banner

Tool to use in order to copy schemas

edited Mar 14, 2017 4:42AM in Database Utilities (MOSC) 6 commentsAnswered ✓

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center