Hi All,
I got a request today to take export of 4 tables from one of the production schema, and that need to be impdp to OAT before that they need to test in a dummy schema So, i created a schema called dummy. i copied the expdp from production to OAT server via SCP All 4 tables are in one dumpfile . while doing imp i am facing some issues . please can i get the correct syntax . i am using the below syntax
impdp system directory=data_pump_dir dumpfile=dummy.dmp logfile=dummy.log
4 tables are already exists in production and OAT , thats why i am trying to create a dummy schema to add my 4 tables for them to test.
thanks in advance