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

In article <36309028.54A7317C_at_earthling.net>,   Jeff <misnomer_at_earthling.net> 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.

ORACLE 8.0.4 export file will not import well into lower versions, such as Pers Ora 8.0.3 due to format changes, such as the CREATE TABLE ... ALTER TABLE that you noted.

If you can get IMP80.EXE on your PC communicating with O8 on the sun, then you can use that to create an importable export file.

        Henry

>
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 04 1998 - 10:07:52 CST