Skip to Main Content

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!

imp into pdb of Oracle 19c from 11g

User_ILWE3Nov 30 2022

Hi,
I have tasked to use import a dmp file from 11g (which the hosting machined has been decommissioned) into the 19c pdb ie. orclpdb.
The command use in the 11g was "exp userid/passwd full=y file=/home/oracle/11gdb.dmp". This was done long before.
The Oracle 19c is just installed and I have created the same userid/passwd (grant admin role) into the orclpdb. I have use this userid/passwd to login via sqlplus.
However when I execute this command "imp userid/passwd full=y file=/home/oracle/11gdb.dmp" , I got the below error :
IMP-00058: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon deniedUsername:
Even I retyped the userid/passwd, I still have the same invalid username/password error.
Did I missed any steps ? Any advise is much appreciated. Thanks

Comments
Post Details
Added on Nov 30 2022
1 comment
1,561 views