Home » RDBMS Server » Server Utilities » Error ORA-00922: during Importing dmp file (Oracle 9.2)
Error ORA-00922: during Importing dmp file [message #341722] Wed, 20 August 2008 02:04 Go to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi,
I am trying import a dump file taken from Orcale Version 9.2. I created a tablespace named ssscon_data and user named ssscon. Granted the new user ssscon admin previledges.

When we are trying to import the dump file through command line using the below command :
imp sss/sss@etgdev file=smalltables.dmp fromuser=ssscon touser=ssscon


It is giving the error:
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option


Please advice as what could be the possible reason for this.

Thanks for looking into this,
Mahi
Re: Error ORA-00922: during Importing dmp file [message #341735 is a reply to message #341722] Wed, 20 August 2008 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to post more.
What returns this error?

Regards
Michel
Re: Error ORA-00922: during Importing dmp file [message #341764 is a reply to message #341735] Wed, 20 August 2008 04:18 Go to previous messageGo to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi Michel,
I have tried to import a dump file named smalltables.dmp which contains some tables data which is exported from version Oracle 9.2 to the same version using the commandline syntax :
imp sss/sss@etgdev file=smalltables.dmp fromuser=ssscon touser=ssscon


It runs for a while....and then gives the error as the last two lines of output :

IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option


Please advice the possible reasons for same. Also please let me know if I am missing on some information that needs to be posted here.

Regards,
Mahi
Re: Error ORA-00922: during Importing dmp file [message #341767 is a reply to message #341764] Wed, 20 August 2008 04:29 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You still didn't post sufficient info.

export dump file is belong to which oracle version?
Re: Error ORA-00922: during Importing dmp file [message #341770 is a reply to message #341767] Wed, 20 August 2008 04:33 Go to previous messageGo to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi Taj,
Nice to see you replying. I looked into your blog dbataj.blogspot.com. Its very informative.

Version is Oracle 9.2 both while exporting and while importing.

Thanks,
Mahi

[Updated on: Wed, 20 August 2008 04:35]

Report message to a moderator

Re: Error ORA-00922: during Importing dmp file [message #341771 is a reply to message #341764] Wed, 20 August 2008 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Repeating a post is NOT posting more information.
WHAT RETURNS THIS ERROR?
What are the lines above?
Just post you log file (the useful lines). Isn't it obvious?

Regards
Michel
Re: Error ORA-00922: during Importing dmp file [message #341787 is a reply to message #341771] Wed, 20 August 2008 05:49 Go to previous messageGo to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi,
Sorry for miscommunication.... I lloked into the versions and the client installed on my computer is version 9.2 but the server is 9.0
So the dump file is taken from oracle version 9.2 and I am trying to import from my computer where client is installed of oracle 9.2 version but the server is 9.0 version.

Please suggest a way to solve this problem as a higher version dump file can't be imported to a lower version. Are there any alternatives.

Also please see the log below:
 "CREATE TABLE "TBL_ERROR_LOG" ("ID" NUMBER(*,0), "ERROR" VARCHAR2(1000), "DE"
 "TAILS" VARCHAR2(4000), "STATUS" NUMBER(*,0), "DATE_CREATED" DATE)  PCTFREE "
 "10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FRE"
 "ELIST GROUPS 1) TABLESPACE "SSSCON_DATA" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_PROCEDURE" ("ID1" NUMBER NOT NULL ENABLE, "PROC_NAME" VAR"
 "CHAR2(50), "DESC1" VARCHAR2(100))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRAN"
 "S 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SSSC"
 "ON_DATA" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_TEAM" ("TEAM_ID" NUMBER(*,0) NOT NULL ENABLE, "TEAM_NAME""
 " VARCHAR2(50), "ACTIVE" NUMBER(*,0), "DATE_CREATED" DATE, "DATE_MODIFIED" D"
 "ATE, "TEAM_CODE" CHAR(4))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 ST"
 "ORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SSSCON_DATA""
 " LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_ROLE_MENUS" ("ROLE_ID" NUMBER(*,0) NOT NULL ENABLE, "MENU"
 "_ID" NUMBER(*,0) NOT NULL ENABLE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRAN"
 "S 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "STKC"
 "ON_DATA" NOLOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_ALERTMSG" ("LOGINALERTID" NUMBER(*,0), "MESSAGE" VARCHAR2"
 "(1000), "FROMDATE_MSG" DATE, "TODATE_MSG" DATE, "STATUS" NUMBER(*,0), "CREA"
 "TED_DATE" DATE, "MODIFIED_DATE" DATE)  PCTFREE 10 PCTUSED 40 INITRANS 1 MAX"
 "TRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE ""
 "SSSCON_DATA" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_LAST_FETCH_DATE" ("NAME" VARCHAR2(100), "FETCH_DATE" DATE"
 ")  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREE"
 "LISTS 1 FREELIST GROUPS 1) TABLESPACE "TBL_STOCKIST" NOLOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "JDE_TEMP_STOCKIST" ("ABAT1" VARCHAR2(25), "ABAN8" NUMBER, "AB"
 "ALPH" VARCHAR2(100), "ABMCU" VARCHAR2(25), "ABAC02" VARCHAR2(25), "ALEFTB" "
 "NUMBER, "ALADD1" VARCHAR2(100), "ALADD2" VARCHAR2(100), "ALADD3" VARCHAR2(1"
 "00), "ALADD4" VARCHAR2(100), "ALADDZ" VARCHAR2(25), "ALCTY1" VARCHAR2(25), "
 ""ALADDS" VARCHAR2(25), "ALCTR" VARCHAR2(25), "A5RYIN" VARCHAR2(25), "ABUPMJ"
 "" NUMBER, "ALUPMJ" NUMBER, "A5UPMJ" NUMBER, "A5KCOR" VARCHAR2(10))  PCTFREE"
 " 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FR"
 "EELIST GROUPS 1) TABLESPACE "SSSCON_DATA" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_DOCUMENT_TYPE" ("DOCUMENT_TYPEID" NUMBER(*,0) NOT NULL EN"
 "ABLE, "DESCRIPTION" VARCHAR2(50), "ACTIVE" NUMBER(*,0), "DATE_CREATED" DATE"
 ", "DATE_MODIFIED" DATE, "DOC_TYPE" VARCHAR2(50))  PCTFREE 10 PCTUSED 40 INI"
 "TRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) T"
 "ABLESPACE "SSSCON_DATA" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_PRODUCT_UOM" ("UOM_CODE" CHAR(5), "UOM_DESCRIPTION" VARCH"
 "AR2(20), "ACTIVE" NUMBER(*,0), "DATE_CREATED" DATE, "DATE_MODIFIED" DATE)  "
 "PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELIS"
 "TS 1 FREELIST GROUPS 1) TABLESPACE "SSSCON_DATA" NOLOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_PROFILE" ("PROFILE_ID" NUMBER(*,0) NOT NULL ENABLE, "PROF"
 "ILE_NAME" VARCHAR2(50) NOT NULL ENABLE, "PROFILE_SHORT_NAME" VARCHAR2(50)) "
 " PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELI"
 "STS 1 FREELIST GROUPS 1) TABLESPACE "SSSCON_DATA" NOLOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_SCROLL" ("SCROLL_ID" NUMBER(*,0), "SCROLL_DESCRIPTION" VA"
 "RCHAR2(4000), "ACTIVE" NUMBER(*,0), "DATE_CREATED" DATE, "DATE_MODIFIED" DA"
 "TE, "FROM_DATE" DATE, "END_DATE" DATE, "STATUS" NUMBER(*,0))  PCTFREE 10 PC"
 "TUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST"
 " GROUPS 1) TABLESPACE "SSSCON_DATA" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_EMAIL_MESSAGES" ("MSG_ID" NUMBER, "SUBJECT" VARCHAR2(250)"
 ", "MESSAGE" VARCHAR2(4000), "SENDER" VARCHAR2(250), "MODULE" VARCHAR2(100),"
 " "DESCRIPTION" VARCHAR2(250))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 25"
 "5 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SSSCON_D"
 "ATA" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_CONTACT_PROFILE" ("PROFILE_ID" NUMBER(*,0), "CONTACT_PROF"
 "ILE_ID" NUMBER(*,0))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE"
 "(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SSSCON_DATA" LOGG"
 "ING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_EXCELDOWNLOAD_STATUS" ("FILE_VERSION" NUMBER, "FILE_NAME""
 " VARCHAR2(500), "USER_CODE" VARCHAR2(25), "DOWNLOADDATE" DATE)  PCTFREE 10 "
 "PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELI"
 "ST GROUPS 1) TABLESPACE "SSSCON_DATA" NOLOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
 "CREATE TABLE "TBL_ERROR_MESSAGE" ("USER_CODE" VARCHAR2(25) NOT NULL ENABLE,"
 " "FILE_NAME" VARCHAR2(250) NOT NULL ENABLE, "UPLOADED_DATE" DATE, "GSK_COMM"
 "ENTS" CLOB, "FILE_PATH" VARCHAR2(250))  PCTFREE 10 PCTUSED 40 INITRANS 1 MA"
 "XTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "
 ""SSSCON_DATA"



Regards,
Mahi

[Updated on: Wed, 20 August 2008 05:53]

Report message to a moderator

Re: Error ORA-00922: during Importing dmp file [message #341799 is a reply to message #341787] Wed, 20 August 2008 06:12 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Some 9.2 features don't exist in 9.0 version.
Check in SQL Reference version 9.0 which option is not valid in your statements.

The correct processing is to export with the lowest version.

Regards
Michel

[Updated on: Wed, 20 August 2008 06:13]

Report message to a moderator

Previous Topic: dmp file
Next Topic: Can I merge two or more exported dumps(*.dmp) ?
Goto Forum:
  


Current Time: Mon Dec 05 15:17:02 CST 2016

Total time taken to generate the page: 0.16590 seconds