OraFAQ Forum: Server Utilities » IMP-00017: following statement failed with ORACLE error 922

Home » RDBMS Server » Server Utilities » IMP-00017: following statement failed with ORACLE error 922 (Oracle 9i, AIX Version 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMP-00017: following statement failed with ORACLE error 922 [message #663015]

Thu, 18 May 2017 08:09

SiuLong
Messages: 12
Registered: May 2017

Junior Member

Hi all
I have a problem

I use a IMP command and returned this error IMP-00017: following statement failed with ORACLE error 922.

Local machine Client Oracle 11.2.0.1.0
Server machine Oracle 9.2.0.8.0
Export using a Oracle V09.02.00

I Copy/Paste the log
-------------------------------------
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning and Real Application Testing options
JServer Release 9.2.0.8.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by SYS, not by you

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P9 character set (possible charset conversion)
export client uses WE8ISO8859P9 character set (possible charset conversion)
. importing NPDS's objects into NPDS
. importing NPDSAPL's objects into NPDSAPL
. importing NPDSTOSIR's objects into NPDSTOSIR
. importing NPDS's objects into NPDS
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE OR REPLACE "
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
.
.
.
.
About to enable constraints...
Import terminated successfully with warnings.

How to solve this problem?
Thanks

Report message to a moderator

[Message index]

		IMP-00017: following statement failed with ORACLE error 922 By: SiuLong on Thu, 18 May 2017 08:09
		Re: IMP-00017: following statement failed with ORACLE error 922 By: BlackSwan on Thu, 18 May 2017 08:19
		Re: IMP-00017: following statement failed with ORACLE error 922 By: SiuLong on Thu, 18 May 2017 08:32
		Re: IMP-00017: following statement failed with ORACLE error 922 By: BlackSwan on Thu, 18 May 2017 08:38
		Re: IMP-00017: following statement failed with ORACLE error 922 By: SiuLong on Thu, 18 May 2017 08:45
		Re: IMP-00017: following statement failed with ORACLE error 922 By: BlackSwan on Thu, 18 May 2017 08:57
		Re: IMP-00017: following statement failed with ORACLE error 922 By: SiuLong on Thu, 18 May 2017 09:00
		Re: IMP-00017: following statement failed with ORACLE error 922 By: cookiemonster on Thu, 18 May 2017 09:02
		Re: IMP-00017: following statement failed with ORACLE error 922 By: BlackSwan on Thu, 18 May 2017 09:04
		Re: IMP-00017: following statement failed with ORACLE error 922 By: SiuLong on Thu, 18 May 2017 09:25
		Re: IMP-00017: following statement failed with ORACLE error 922 By: BlackSwan on Thu, 18 May 2017 09:26
		Re: IMP-00017: following statement failed with ORACLE error 922 By: cookiemonster on Thu, 18 May 2017 09:38
		Re: IMP-00017: following statement failed with ORACLE error 922 By: SiuLong on Thu, 18 May 2017 09:43
		Re: IMP-00017: following statement failed with ORACLE error 922 By: cookiemonster on Thu, 18 May 2017 09:41
		Re: IMP-00017: following statement failed with ORACLE error 922 By: SiuLong on Fri, 19 May 2017 03:26
		Re: IMP-00017: following statement failed with ORACLE error 922 By: SiuLong on Mon, 29 May 2017 03:15
		Re: IMP-00017: following statement failed with ORACLE error 922 By: Michel Cadot on Mon, 29 May 2017 03:26
		Re: IMP-00017: following statement failed with ORACLE error 922 By: SiuLong on Wed, 06 September 2017 04:22
		Re: IMP-00017: following statement failed with ORACLE error 922 By: cookiemonster on Wed, 06 September 2017 04:55
		Re: IMP-00017: following statement failed with ORACLE error 922 By: EdStevens on Wed, 06 September 2017 07:06
		Re: IMP-00017: following statement failed with ORACLE error 922 By: SiuLong on Thu, 07 September 2017 04:26
		Re: IMP-00017: following statement failed with ORACLE error 922 By: joy_division on Thu, 07 September 2017 08:23
		Re: IMP-00017: following statement failed with ORACLE error 922 By: SiuLong on Fri, 08 September 2017 02:17
		Re: IMP-00017: following statement failed with ORACLE error 922 By: cookiemonster on Fri, 08 September 2017 04:18
		Re: IMP-00017: following statement failed with ORACLE error 922 By: SiuLong on Fri, 08 September 2017 04:44
		Re: IMP-00017: following statement failed with ORACLE error 922 By: joy_division on Fri, 08 September 2017 07:54
		Re: IMP-00017: following statement failed with ORACLE error 922 By: ctvarner on Wed, 04 October 2017 14:04

Previous Topic:	the user data import problem in window 8
Next Topic:	Exp in Oracle 12c

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 17:59:10 CDT 2024