Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Export Problem

Re: Oracle Export Problem

From: EdStevens <quetico_man_at_yahoo.com>
Date: 28 Sep 2005 13:19:28 -0700
Message-ID: <1127938768.045735.20610@g44g2000cwa.googlegroups.com>

BN wrote:
> 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

Just like the error message says: "please notify your DBA"

Now, if you ARE the DBA ... ;-0

A quick search of MetaLink shows several possibilities. Most likely an upgrade applied and not properly completed vis a vis the data dictionary. Do a MetaLink search on EXP-00024 for details. Received on Wed Sep 28 2005 - 15:19:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US