Re: Oracle Export Problem

From: Hubert Kordas <Hubert.Kordas_at_interia.pl>
Date: Wed, 28 Sep 2005 22:26:19 +0200
Message-ID: <dheuaj$lqn$1@news.interia.pl>

You probably need to run (or in some cases - after patches, upgrades - rerun) catexp.sql script.

As SYS: <$ORACLE_HOME>/rdbms/catexp.sql

This should help.
I think that without more informations (is this 'fresh' database, is the 'exp' utility in same version as database, etc) I can only suggest you to do more research on 'catexp.sql' and 'exp views' - metalink is reliable source of information ;-)

Hubert

"BN" <BN_at_BN.COMO> wrote in message
news:11jlsvh705bkn77_at_news.supernews.com...
> I unsuccessfully tried to export data from Oracle with:
>
> Export: Release 9.2.0.4.0 - Production on Wed Sep 28 15:47:17 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to: Oracle9i Release 9.2.0.4.0 - Production
> JServer Release 9.2.0.4.0 - Production
> Export done in US7ASCII character set and AL16UTF16 NCHAR character set
> server uses WE8ISO8859P1 character set (possible charset conversion)
>
> About to export specified users ...
> . exporting pre-schema procedural objects and actions
> . exporting foreign function library names for user USER1
> . exporting PUBLIC type synonyms
> . exporting private type synonyms
> . exporting object type definitions for user USER1
> 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
>
>
> How can this be resolved?
>
> Thanks
Received on Wed Sep 28 2005 - 15:26:19 CDT