Re: URGENT (PLEASE): Oracle8 Export problem - makes NO sense!!!

A copy of this was sent to Rene <rene_at_webhost.co.za> (if that email address didn't require changing) On Sat, 17 Oct 1998 13:17:15 +0200, you wrote:

>Hi there all,
>
>I really need help desperately on this problem.
>
>Please mail rene_at_webhost.co.za with your reply.
>
>Scenario:
> - running Oracle 8.0.4.0.0 on Sun Solaris 2.5.1
>
>Problem:
> - I am trying to create an export file of the database, and in order to
>do this I try the following:
>
> - In a telnet session, I type:
>/export/app/oracle/product/8.0.4/bin/exp dba_username/dba_password
>
> - I get the following output:
>BEGIN OUTPUT-------------------------------------------
>Export: Release 8.0.4.0.0 - Production on Sat Oct 17 12:58:13 1998
>
>(c) Copyright 1997 Oracle Corporation. All rights reserved.
>
>
>Connected to: Oracle8 Release 8.0.4.0.0 - Production
>PL/SQL Release 8.0.4.0.0 - Production
>EXP-00037: Export views not compatible with database version
>EXP-00000: Export terminated unsuccessfully
>END OUTPUT-------------------------------------------
>
>As you can see the export utility IS the same version as the database it
>is connecting to, yet I get the "incompatibility" error.
>
>How is this possible, and is there anyone that could help solve this
>problem????
>
>Please&ThankYou4AnyHelp
>Rene

Sounds like the script $ORACLE_HOME/rdbms/admin/catexp.sql was not run after an upgrade. Please try executing this script using svrmgrl when connected as SYS or INTERNAL. For example:

$ cd $ORACLE_HOME/rdbms/admin
$ svrmgrl

SVRMGR> connect internal
SVRMGR> _at_catexp

This script builds the views used by export and will correct the problem.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.