IMP Utility Version doubt [message #73970] |
Thu, 12 August 2004 09:31 |
Prasad
Messages: 104 Registered: October 2000
|
Senior Member |
|
|
Hello All,
We have exported schema from Oracle9.2.0.3.0 and I am importing the schema in Oracle9.0.1.1.1.
I am able to import the packages,type and synonyms.but when it come to tables I ended up with the following error log for all the tables in my exported schema.
Example:
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "SC_CATEGORY" ("CATEGORY_ID" NUMBER(2, 0) NOT NULL ENABLE, "NA"
"ME" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(IN"
"ITIAL 131072 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "T_SCO" LOGGING NOCO"
"MPRESS"
Kindly suggest me the solution,what i am doing wrong!!
Thanks and Rgds
Prasad
|
|
|
|