Skip to Main Content

Oracle Database Discussions

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 from 11.2 to 18c

c1137a5a-85cb-4bf2-af5e-7da180d76982Jan 27 2020 — edited Jan 27 2020

Hello,

I would like to import a .dmp file using impdp (the .dmp has been exported from oracle database 11g). I'm on Windows 10.

I use this command:

impdp system/***  DUMPFILE=DUMP.dmp LOGFILE=DUMPP.log

It reads the .dmp but everything fails. I manually created table spaces to solve the first errors, but then I have hundreds of:

ORA-39083 - Echec de la création du type d'objet ... avec erreur:

ORA-65096 : nom d'utilisateur ou de role commun non valide

I can't manage to create users/roles manually with sqlplus / as SYSDBA

I tried to create a non-container database with DBCA but I don't know how to connect.

Thanks a lot!

Comments
Post Details
Added on Jan 27 2020
7 comments
800 views