Marinus Damm wrote:
>
> 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
Your are using the 8.0.5 export utility to export a 8.0.4 database.
Either use 8.0.4's export or run 8.0.5's catexp.sql on the 8.0.4
database.
Received on Thu May 27 1999 - 15:35:01 CDT
