By
Published: 07 May 2009
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
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Continue Reading