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

Did you set the RECORDLENGTH parameter during export? You got to use this between not binary-compatible systems. Remember to use it during import also.

Just my 2c.

Petter Henrik Hansen

Jeff wrote:

> 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 - 18:41:25 CDT