Re: Export from 8.0 to 7.0 ?

On Sat, 29 May 1999 19:52:59 +0200, Ernst de Haan wrote (in message <3750297B.80344C53_at_znerd.demon.nl>):
>
> Hi all,
>
>
> We've got two sites, one is running an Oracle 8 database and the other runs
> Oracle 7. I used the 'exp' tool to create an export of the Oracle 8 database
> tables (both structure and content), but Oracle 7 fails to import the data,
> telling me that the header is invalid. I've tried to enable/disable the
> options (like compress extent for example), but that doesn't change
> anything.
>
> Would anyone know how to make Oracle 7 import the Oracle 8 export file? A
> utility to convert from 7 to 8 would help, too. I cannot find anything in
> the Oracle 8 bin/ directory that looks like "exp_to_7".

Hi Ernst,

just create the v7 export views in the v8 database and use the v7 exp utillity to export the database like you want. Check $ORACLE_HOME/rdbms/admin/catexp7.sql (not 100% sure about the exact filename but it's obvious when you see the file list).

-- 
Ronald - certified Oracle DBA http://home.wxs.nl/~ronr/professional.html
       - unix/sa              http://www.tresco.nl/dcl.html
       - Middleware programmer/
                      designer    mailto:R.Rood_at_tresco.nl