Posted on 2010-09-20
I' m using windows 2008 for Oracle 11G.
I have two databases in Oracle one is for production and the other is for development.
I' m trying to take export of schema x from production DB and import the export file in schema Y of development DB. I take the export of schema X in production DB successfully. But I try to make import I get errors,
I use the following command,
expdp X/zzzz schemas=X directory='DATA_PUMP_DIR' dumpfile=exp_normal.dmp logfile=exp_normal.log
impdp Y/aaaa schemas=X directory=DATA_PUMP_DIR dumpfile=exp_normal.dmp logfile=imp_normal.log
What is wrong?