Importing DMP file to Oracle9i

[Hoppkins]

Hi,

I have a dmp file to import into Oracle 9i. I have created the tablespace and user and assigned all needed privilages.

However i'm coming a bit unstuck at the import utility.

I've used the Oracle8i imp utility from a batch file before but this same process does not seem to work.

This is what i was using (in batch file form):

pause
imp userid=system/manager file='xxxxx_yyy_14092005_OracleDB_live_Oracle9.dmp' fromuser='libuser' touser='libuser'
pause

It terminates with errors a small section of which is below..any help would be gratefully received.

Thanks


Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
. importing LIBUSER's objects into LIBUSER
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'LIBUSER', export_db_na"
"me=>'TESTORA.US.ORACLE.COM', inst_scn=>'62935272');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "TACQMETHOD" ("FSYSTEMKEY" CHAR(36) NOT NULL ENABLE, "FDTTMCRE"
"ATED" DATE, "FUSERCREATED" CHAR(36), "FDTTMMODIFD" DATE, "FUSERMODIFD" CHAR"
"(36), "FCODE" VARCHAR2(11 CHAR), "FCODEDESC" VARCHAR2(128 CHAR), "FDEFCODEF"
"LAG" NUMBER(1, 0), "FENRECDEL" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITRAN"
"S 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLE"
"SPACE "SYDNEY" 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 "TAQCOSTSPLIT" ("FSYSTEMKEY" CHAR(36) NOT NULL ENABLE, "FDTTMC"
"REATED" DATE, "FUSERCREATED" CHAR(36), "FDTTMMODIFD" DATE, "FUSERMODIFD" CH"
"AR(36), "FCODE" VARCHAR2(11 CHAR), "FCODEDESC" VARCHAR2(128 CHAR), "FDEFCOD"
"EFLAG" NUMBER(1, 0), "FENRECDEL" NUMBER(1, 0)) PCTFREE 10 PCTUSED 40 INITR"
"ANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TAB"
"LESPACE "SYDNEY" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:

 

[Hoppkins]

I think i have found the problem...

Seems we are using Oracle 9.0.1....

and the dmp file was created with 9.0.2.

Would this be a problem?

Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production

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

 

[KenCunningham]

Could be. exports aren't generally backwardly compatible. Could you upgrade the database you wish to import into?