Home » RDBMS Server » Server Administration » ORA-00922: missing or invalid option (Oracle9i Release 9.0.1.1.1 - Production - XP)
ORA-00922: missing or invalid option [message #382242] Wed, 21 January 2009 08:44 Go to next message
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.
Re: ORA-00922: missing or invalid option [message #382253 is a reply to message #382242] Wed, 21 January 2009 09:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: ORA-00922: missing or invalid option [message #382257 is a reply to message #382253] Wed, 21 January 2009 10:00 Go to previous messageGo to next message
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?

Re: ORA-00922: missing or invalid option [message #382258 is a reply to message #382242] Wed, 21 January 2009 10:03 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: ORA-00922: missing or invalid option [message #382260 is a reply to message #382257] Wed, 21 January 2009 10:10 Go to previous message
Mahesh Rajendran
Messages: 10672
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:
  


Current Time: Sun Dec 11 00:27:17 CST 2016

Total time taken to generate the page: 0.09599 seconds