Q

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.
This was first published in May 2009

Dig Deeper

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close