Re: catexp7.sql

Stan Brown wrote:
>
> I'm trying to use the tools that came wiht a 9i Linux install to back up a
> 7.3.4.5 DB. Do I need to run catexp7.sql on the new (91) instance to allow
> this to happen? The comments in it say the iverse, that say that i't
> needed to allow the V7 tools to back up the v9 DB.
>
> However, I am getting errors whne I try to back up the V7 db:
>
> Script started on Mon Oct 15 08:41:18 2001
> oracle_at_debian:/dumpdisk/tmp$ exp
>
> Export: Release 9.0.1.0.0 - Production on Mon Oct 15 08:41:22 2001
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> Username: sys
> Password:
>
> EXP-00008: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> EXP-00024: Export views not installed, please notify your DBA
> EXP-00000: Export terminated unsuccessfully
> oracle_at_debian:/dumpdisk/tmp$
> Script done on Mon Oct 15 08:41:40 2001

Generally spoken you can expect many compatibility problems when exporting a Oracle 7 DB with a Oracle 9 client. This won't work since the exp code relies on many views not present in Oracle 7.

I always suggest running exp locally. It's faster and reliable. Afterwards you can copy the dump files wherever you want.

Think about exporting into a named pipe which allows you to compress, split and remote copy your data.

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Karlsdorfer Str. 31 | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!