Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error in export (ORA-00904: invalid column name)
This can happen if catexp.sql was not execute after an upgrade.
You'll find it in your $ORACLE_HOME/rdbms/admin directory.
--
Have a nice day
Michel
Eric DUCHET <eric.duchet_at_free.fr> a écrit dans le message :
8NR04.3773$hZ5.17740906_at_nnrp1.proxad.net...
> Hi,
>
> When I execute the export command on my Database,
> i've got the error message
>
> ORA-00904: invalid column name
>
> What does it mean ?????
>
> Here is the trace from my exp command
>
> Thanx in advance
>
> exp
>
> Export: Release 7.3.4.0.0 - Production on Tue Nov 30 15:56:43 1999
>
> Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
>
> Username:
>
> Connected to: Oracle7 Server Release 7.3.4.0.0 - Production
> With the distributed and parallel query options
> PL/SQL Release 2.3.4.0.0 - Production
> Enter array fetch buffer size: 4096 >
>
> Export file: expdat.dmp >
>
> (1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 3
>
> Export table data (sim/não): sim >
>
> Compress extents (sim/não): sim >
>
> Export done in WE8ISO8859P1 character set
>
> About to export specified tables via Conventional Path ...
> Table to be exported: (RETURN to quit) > receptacletypes
>
> . . exporting table ITEMTYPES 4 rows exported
> EXP-00008: ORACLE error 904 encountered
> ORA-00904: invalid column name
> Table to be exported: (RETURN to quit) >
> EXP-00008: ORACLE error 904 encountered
> ORA-00904: invalid column name
> EXP-00222:
> System error message 4
> EXP-00000: Export terminated unsuccessfully
>
>
Received on Tue Nov 30 1999 - 10:09:52 CST