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!

Import Error --- needed urgent

540353Dec 13 2006 — edited Apr 13 2011

Hi,

I am working in oracle 9i and linux 2.4. I have the export .dmp file. if i using import it shows error

ORA-01917: user or role 'CIM_APP' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT EXECUTE ON "GEAE_CIMS_CI" TO "CIM_WEB""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'CIM_WEB' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT EXECUTE ON "GEAE_CIMS_BIZ_ADMIN" TO "CIM_UPDATER""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'CIM_UPDATER' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT EXECUTE ON "GEAE_CIMS_BIZ_ADMIN" TO "CIM_LOOKER""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'CIM_LOOKER' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT EXECUTE ON "GEAE_CIMS_BIZ_ADMIN" TO "CIM_APP""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'CIM_APP' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT EXECUTE ON "GEAE_CIMS_BIZ_ADMIN" TO "CIM_WEB""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'CIM_WEB' does not exist
Import terminated successfully with warnings

please explain me the sql query

Gobi.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 11 2011

Added on Dec 13 2006

#general-database-discussions

3 comments

17,247 views