Re: Full export fails... suggestions?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 27 May 1999 22:39:12 +0200
Message-ID: <927837450.9049.0.pluto.d4ee154e@news.demon.nl>

Hi Marinus
Usually this is being caused by forgetting to run $ORACLE_HOME/rdbms/admin/catexp.sql using svrmgrl

Hth,

Sybrand Bakker, Oracle DBA

Marinus Damm wrote in message <374D9707.A2090175_at_cdg.cendant.com>...
>Hiya,
>
>If I attempt a full export as user system against Oracle 8 on Solaris,
>this is the result:
>-------------------------------------------------------------------
>Export: Release 8.0.5.0.0 - Production on Thu May 27 11:46:44 1999
>
>(c) Copyright 1998 Oracle Corporation. All rights reserved.
>
>
>Connected to: Oracle8 Enterprise Edition Release 8.0.4.2.1 - Production
>PL/SQL Release 8.0.4.2.1 - Production
>Export done in US7ASCII character set and US7ASCII NCHAR character set
>Note: table data (rows) will not be exported
>
>About to export the entire database ...
>. exporting tablespace definitions
>EXP-00008: ORACLE error 904 encountered
>ORA-00904: invalid column name
>EXP-00000: Export terminated unsuccessfully
>
>===================================================================
>
>User exports against 'sys' or 'system' succeed. Is there a
>straightforward way to identify the offending column?
>--
>Marinus Damm
>
>425-456-3507
>marinus.damm_at_cdg.cendant.com
Received on Thu May 27 1999 - 15:39:12 CDT