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

Make sure you don't have objects
defined in your exported database

PO8 doesn't support Oracle Objects
option

HTH Madhu Cherukuri

Jeff wrote in message <36309028.54A7317C_at_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:
> 4
>
>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 - 19:59:09 CDT