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!

Import .dmp Oracle 10G

934983May 4 2012 — edited May 4 2012

Regards

Partners of the Forum

You install the Oracle 10G on Windows Server 2008 and also installed the patch that necesitava to work properly (Test Data Base), the only users who have are own system, but to make the import of files . dmp presents the following problem:

MP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "SC_TMVCO" TO "CXP""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: el usuario o rol 'CXP' no existe
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT REFERENCES ON "SC_TMVCO" TO "CXP""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: el usuario o rol 'CXP' no existe
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DELETE ON "SC_TMVCO" TO "ADMINISTRADOR""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: el usuario o rol 'ADMINISTRADOR' no existe
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT INSERT ON "SC_TMVCO" TO "ADMINISTRADOR""
IMP-00003: ORACLE error 1917 encountered ... etc...

please can help me to successfully import the backup files .dmp to the new Oracle Database 10g.