Re: Exporting Version 7.0 DB to Version 6.0

In article <3l6dj8$fu_at_nic.ott.hookup.net>, GrahamB_at_psac.com (Brian Graham) says:
>
 

> From the Oracle 7 Server Migration Guide, Migration Overview page 1-5,
>"Note that you cannot import an Oracle7 export into a Version 6 database."
>Note that the overview says that you can send the table data to a V6
>database with the Sql*plus COPY command, via CREATE TABLE AS SELECT, and
>by running CATEXP6.SQL on your V7 database, and then exp/imp. The last step
>should NOT be done to a continued production V7 database.

  Allow me to clarify one point. The "LAST STEP" should read "LAST METHOD". Ie, running CATEXP.SQL is intended for reverse migration as opposed to regularly moving data back to a production V6 database.   Hopefully this is a little clearer than mud, now..

                                        Brian

--
Brian Graham                    .
Programmer / DBA        ._______|_______. Tel: 613-560-5470
Public Service Alliance       \(*)/       Fax: 613-563-3492
of Canada                     o/ \o       Email: grahamb_at_psac.com