Export on Oracle 8 Solaris, Import on Personal Oracle 8 Win95

From: Jeff <misnomer_at_earthling.net>
Date: Fri, 23 Oct 1998 22:18:16 +0800
Message-ID: <36309028.54A7317C@earthling.net>

I have a .dmp file created by exp80 under Solaris. Just installed Personal Oracle under Win95 and imp80 gives me all sorts of errors. Only about 3 tables imported out of 129. It seems as it it can't parse/read the .dmp file correcty. I've attached a small selection of the errors below.

Looking into the .dmp file there are CREATE TABLE statements followed by a series of ALTER TABLE MODIFY column DEFAULT 0

Notice how it seems most of the CREATEs are unrecognised and the 0 is dropped off the ALTER.

Connected to: Personal Oracle8 Release 8.0.3.0.0 - Production With the Partitioning option
PL/SQL Release 8.0.3.0.0 - Production

Export file created by EXPORT:V08.00.04 via conventional path

Warning: the objects were exported by UNCJDL, not by you

. importing UNCJDL's objects into PO8
IMP-00017: following statement failed with ORACLE error 921:
"ALTER TABLE "ARRAYETABLE" MODIFY DEFAULT"

IMP-00003: ORACLE error 921 encountered
ORA-00921: unexpected end of SQL command
IMP-00008: unrecognized statement in the export file:

5
IMP-00008: unrecognized statement in the export file: @
IMP-00017: following statement failed with ORACLE error 921:
"ALTER TABLE "ARRAYTABLE" MODIFY DEFAULT"

IMP-00003: ORACLE error 921 encountered
ORA-00921: unexpected end of SQL command
IMP-00008: unrecognized statement in the export file:

  4
IMP-00008: unrecognized statement in the export file:   A
IMP-00008: unrecognized statement in the export file:   @
IMP-00008: unrecognized statement in the export file:   B
IMP-00008: unrecognized statement in the export file:   ?

. . importing table                "CLASSBYTECODE"          0 rows

imported
IMP-00017: following statement failed with ORACLE error 921:
"ALTER TABLE "CLASSTABLE" MODIFY DEFAULT"

IMP-00003: ORACLE error 921 encountered
ORA-00921: unexpected end of SQL command
IMP-00008: unrecognized statement in the export file:

I have to admit I'm a newbie but I'd be very grateful for any help. I also tried running imp80 as system/manager but it didn't make any difference.

Jeff Received on Fri Oct 23 1998 - 09:18:16 CDT