Re: Import/Export

No catexp8.sql doesn't exist, but catexp7 still does.

With regard to the original question, there's a paper on my site where I laboriously worked out what version of which utility has to be run to allow cross-version exports and imports to take place (its under Tips, backup and recovery).

The net result is that if you run catexp7 in the Oracle 9i database, you'll be able to export from 9i into an Oracle 7-version dumpfile. Version 8 import will then be able to read that file. So what I think you were suggesting is indeed the way to go -but he'll have to use version 7 files to do the transfer.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Tim Shute" <tshute_at_nisoft.com> wrote in message
news:6bef18b738ddb650fd18efeed0de5a16.46509_at_mygate.mailgate.org...


> "Kurt Bilde" <kub_at_sam.sdu.dk> wrote in message

> news:3C3D7369.4030007_at_sam.sdu.dk...

>

> > Hi !

> >

> > We are using Oracle9i at work but I have 8i personal edition at home in

> > order to work at home sometimes. When working at home I would like to

> > take a user's tables, triggers and sequences with me home in a file due

> > to the fact that there is no online communication between my home and my

> > work. Is it posible to dump all users stuff into a file and get it back

> > into my db at home(from 9i to 8ipersonal and the other way

around)???????


> >

> > -Kurt

>

> In Oracle 8 there is / was a script called CATEXP7.SQL that created the

> relevant objects to allow an Oracle 7 compatible export to be created.

>

> I assume there is something similar (CATEXP8?) for Oracle 9i.

>

> The problem with CATEXP7 was that you then had to connect to the Oracle8

> database using an Oracle7 client to run EXP73, which was a bit of a pain.

>

> Hope this helps.

>

> Tim.

> ==

>

>

>

> --

> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG