text: Q:
  
  Oracle DB expdp and impdp issue
  
  I have created many interlinked tables as user "SCOTT" in oracle DB.
  I want to copy these tables plus their data to new user "PRODUCTION"
  For exporting data from "SCOTT", i used :
  ./expdp  scott schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log  CONTENT=ALL
  Now for importing it, when i am using command :
  ./impdp PRODUCTION directory=TEST_DIR dumpfile=SCOTT.dmp logfile=impdpSCOTT.log CONTENT=ALL 
  , no table is getting created in PRODUCTION.
  The output of above command (impdb) is "Job "PRODUCTION"."SYS_IMPORT_FULL_01" successfully completed'.
  Please help me to solve issue.
  Thanks
  
  A:
  
  You need to add paraneter REMAP_SCHEMA=SCOTT:PRODUCTION. See the impdb documentation. Without it, there is nothing in the export that is relevant to your production user.
  
  