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 |
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 #341764 is a reply to message #341735] |
Wed, 20 August 2008 04:18 |
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 #341787 is a reply to message #341771] |
Wed, 20 August 2008 05:49 |
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
|
|
|
|
Goto Forum:
Current Time: Tue Dec 24 11:14:24 CST 2024
|