Re: Export

From: Roger Jackson <rjackson_at_wire.net.au>
Date: 2000/06/14
Message-ID: <8i7o97$ua7$1@news1.wire.net.au>#1/1

Andrew,

Yes, you can use the imp/exp executables supplied with Oracle 8i but you also need to run the catexp.sql script for Oracle 8i against the Oracle 8.0.5.1 database before doing the export/import.

ie. you need to use the Oracle 8i export/import views with the Oracle 8i executables to avoid any potential problems while performing the import into the 8.0.5.1 database.

Once you have finished the import re-run the catexp.sql script supplied with Oracle 8.0.5.1 against your 8.0.5.1 database.

Ideally, you should use the imp/exp executables, views etc.. supplied with Oracle 8.0.5.1 if you are performing an export/import for the same Oracle version.

Cheers,

Roger.

"Andrew B. Schexnaydre" <aschexn1_at_tampabay.rr.com> wrote in message news:3946E685.64D31BD7_at_tampabay.rr.com...
> Can I use export/import that comes with Oracle 8i to export
> data from a Oracle 8.0.5.1 database and then import the data
> into another 8.0.5.1 instance?
>
> Thanks,
> Andy
>
Received on Wed Jun 14 2000 - 00:00:00 CDT