Manage Learn to apply best practices and optimize your operations.

How to solve an Oracle import error

Oracle expert Brian Peasland explains how to solve an Oracle import error received after taking a table export and importing it into Oracle 10g.

I am using Oracle 10g (Release 1). I have taken a table export from a schema which is in Oracle 9i (9.2.0) using the exp command, and it successfully completed without warnings. But when I import into my Oracle 10g server from the same export file, it is giving the following error:

IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'QS_ADM' does not exist
IMP-00017: following statement failed with ORACLE error 1917
ORA-01918: user 'WKSYS' does not exist
IMP-00015: following statement failed because the object already exists:
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully

Please help me out.

Precreate the QS_ADM user or role and the WKSYS user on the target database and you will not have this error.

Dig Deeper on Oracle database backup and recovery