Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

impdp utility throwing an oracle 1017 error

rjilaniOct 13 2009 — edited Feb 13 2012

Hi: gurus I exported an schema using expdp utility. I exported the schema being the schema owner. E.g lets say the schema name is clincialgov I used the following command

expdp clinicalgov/password PARFILE=dmpexport.txt, and here is the content of the parameter file "dmpexport.txt"

SCHEMAS=clinicalgov
CONTENT=ALL
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=clinicalgov.dmp

I am trying to import the dump file using the impdp utility like this

impdp clinicalgov/password FULL=Y directory=DATA_PUMP_DIR dumpfile=clinicalgov.dmp logfile=impdpclinicalgov.log

but having the following errors

UDI-00008: operation generated ORACLE error 1017
ORA-01017: invalid username/password; logon denied

BTW I already created a schema/user at the destination database with DBA, Connect, and IMP_FULL_DATABASE.

I also tried to use the schemas switch instead of full but no luck

impdp clinicalgov/password schemas=clincialgov directory=DATA_PUMP_DIR dumpfile=clinicalgov.dmp logfile=impdpclinicalgov.log

Can some one please help and let me know why i am getting this error.

Thanks,
RJ.