Re: Export - EXP-00008: ORACLE error 904 encountered NT4 8.

Sure. In this context it means that when export did the select to get your data it included a column name not in the table. I dont work on the same version you do, with mine it took a patch to fix. Your intention of calling support is the right way to go.

Allan
----- Original Message -----
From: "Paul Drake" <drake_at_psscorp.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, September 13, 2000 10:15 PM Subject: HELP: Export - EXP-00008: ORACLE error 904 encountered NT4 8.

> In examining my export log on a database this evening, I noticed the
> following output at the bottom of the log file:
>
> EXP-00008: ORACLE error 904 encountered
> ORA-00904: invalid column name
> EXP-00000: Export terminated unsuccessfully
>
> So I cannot count on the logical exports for a database restore.
> I do have weekly cold backups and nightly hot backups (archivelog).
>
> Operating System: WinNT Server 4.0
> Service Pack 6a
> RDBMS Oracle 8i R2 Standard Edition
> Version 8.1.6.0.0 +
> Patches 8.1.6.1.1
> 8.1.6.1.2
> No iFS, no Intermedia.
>
>
> Its too late for me to call Oracle US Support, and this will have to wait
> for tomorrow - but:
>
> Has anyone seen this before?
>
> thanks in advance for the help, this is most upsetting.
>
> Paul
>
> Paul Drake
> Professional Software Systems
> --
> Author: Paul Drake
> INET: drake_at_psscorp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Sep 14 2000 - 23:22:01 CDT