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