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.