OraFAQ Forum: Server Administration » ORA-00922: missing or invalid option

Home » RDBMS Server » Server Administration » ORA-00922: missing or invalid option (Oracle9i Release 9.0.1.1.1 - Production - XP)

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

ORA-00922: missing or invalid option [message #382242]

Wed, 21 January 2009 08:44

rashee.2511
Messages: 2
Registered: January 2009
Location: UK

Junior Member

Hello,

I have an export of a schema. I got a warning while doing an import of the schema I had.
I am using oracle 9i in an XP machine.

The following is the log of errors.

IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "LIVE_IMPORT_EU_ETS_PRICES" ("SETTLEMENT_DATE" DATE NOT NULL E"
"NABLE, "IMPORT_ID" NUMBER NOT NULL ENABLE, "PRICE" NUMBER NOT NULL ENABLE) "
" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 1048576 FREE"
"LISTS 1 FREELIST GROUPS 1) TABLESPACE "TBS_ICE_LIVE_DATA" LOGGING NOCOMPRES"
"S"

I am not sure of the db version from which the dmp was exported.
I am trying to import it into 'Oracle9i Release 9.0.1.1.1 - Production' version.
The same dmp file was successfully imported into 'oracle database 10g Enterprise Edition release 10.2.0.1.0 - production' successfully.

I am not an oracle expert. I have some basic knowledge.
Why do I have that error and how can I fix it?

Any help on this will be appreciated.
Thanks in advance.

Report message to a moderator

Re: ORA-00922: missing or invalid option [message #382253 is a reply to message #382242]

Wed, 21 January 2009 09:37

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Check import session or log.
You will see something like this right at the beginning

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

Report message to a moderator

Re: ORA-00922: missing or invalid option [message #382257 is a reply to message #382253]

Wed, 21 January 2009 10:00

rashee.2511
Messages: 2
Registered: January 2009
Location: UK

Junior Member

From the log file I can see 'Export file created by EXPORT:V09.02.00 via conventional path'.

What version of Oracle does it indicate?
Is it because that I am importing a dump exported in higher version of oracle into a lower version of oracle, i am not able to import successfully?

Report message to a moderator

Re: ORA-00922: missing or invalid option [message #382258 is a reply to message #382242]

Wed, 21 January 2009 10:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is it because that I am importing a dump exported in higher version of oracle into a lower version of oracle, i am not able to import successfully?
YES
It might be simpler to upgrade Oracle if you can still obtain the patchset to do so.

Report message to a moderator

Re: ORA-00922: missing or invalid option [message #382260 is a reply to message #382257]

Wed, 21 January 2009 10:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

As said,
upgrading is a wise option.
If you cannot afford it right away,
You need to hack a certain views and run a certain script so that Oracle will understand version differences.
I would not recommend this, though I have done it many times.
Or
>>The same dmp file was successfully imported into 'oracle database 10g Enterprise Edition release 10.2.0.1.0 - production' successfully.

Now that you have the data in 10g database,
use the 9x version of exp to export from 10g,
and use same 9x version of imp to import into 9x.

[Updated on: Wed, 21 January 2009 10:12]

Report message to a moderator

Previous Topic:	archivelog sequencing
Next Topic:	Unable to find out the SCN to perform the incompete recovery (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 15:37:41 CST 2024