Re: catexp7.sql

In <3BCB111D.8F5682AF_at_richard-schneider.de> Uwe Schneider <uwe_at_richard-schneider.de> writes:

>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.

The object of this, is to remove the load from the production DB server. exp is run once a day for recovery purposes (yes there are other better ones used also, but this one lets us restore individual tbales esaily). During this tim, the exp process itself (not counting background db process) uses about 30% of the cPU.

I got this working using a V8 exp clinet, but that machine dies, and I lost all my work :-(

Sugestions?

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin