Re: Import Oracle 8 export file into an Oracle 7.3 db?

Tim Weiler <weilert_at_aseco.net.remove> wrote in message news:_iJK3.537$di5.21177243_at_interramp...
> I have an Oracle 8 export file and I need to import it into a 7.3
database.
> Is this possible? We have both Oracle 8 and 7.3 setup on our network, but
> the Ora 8 db .exp file is from an external database.
> Any suggestions?
> Thanks,
> Tim
>
> PS Remove the '.remove' in my e-mail to e-mail me directly

You can not use the EXP80 export file to import to Oracle7.x. You must use EXP73 to export data.

The following is quoted from "Oracle8 Utility".

You can create an Oracle release 7 export file from an Oracle8 database by running Oracle release 7 Export against an Oracle8 server. To do so, however, the user SYS must first run the CATEXP7.SQL script, which creates the export views that make the database look, to Export, like an Oracle release 7 database.

Note: An Oracle8 Export requires that the CATEXP.SQL script is run against the database before performing the Export. CATEXP.SQL is usually run automatically when the user SYS runs CATALOG.SQL to create the necessary views. CATEXP7.SQL, however, is not run automatically and must be executed manually. CATEXP7.SQL and CATEXP.SQL can be run in any order; after one of these scripts has been run, it need not be run again. Received on Thu Oct 07 1999 - 11:46:32 CDT