I've produced many interconnected tables as user "SCOTT" in oracle DB. I wish to copy these tables plus their data to new user "PRODUCTION"

For conveying data from "SCOTT", i made use of :

./expdp scott schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log CONTENT=ALL

Let's focus on posting it, after i am using command :

./impdp PRODUCTION directory=TEST_DIR dumpfile=SCOTT.dmp logfile=impdpSCOTT.log CONTENT=ALL

, no table gets produced being produced. The creation of above command (impdb) is "Job "PRODUCTION"."SYS_IMPORT_FULL_01" effectively completed'.

Help me to resolve problem.


You have to add paraneter REMAP_SCHEMA=SCOTT:PRODUCTION. Begin to see the impdb documentation. Without them, there's nothing within the export that's highly relevant to your production user.