Re: catexp7.sql

"Stan Brown" <stanb_at_panix.com> wrote in message news:9qeusm$hbt$1_at_panix3.panix.com...
> 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
>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin

This question has been answered many times, and I don't think the search machine at groups.google.com is really that bad. But anyway:
you need to run catexp7.sql in order to be capable to run *the exp from **version 7** against the 9i database.
The reverse will *not* work. You *can't run* a *higher* version export against a *lower* version database.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Mon Oct 15 2001 - 11:38:05 CDT