Hi Paul
Is it a brand new database or just migrated from another version ?
Have you run $ORACLE_HOME/rdbms/admin/catexp.sql ?
Have you ever had a successful export of this database before ?
Are you running a correct version of exp utility ?
Try to re-run $ORACLE_HOME/rdbms/admin/catexp.sql
With regards
Alex Afanassiev
Oracle DBA, TOC OPS/Internet.Operations
Tel: (03) 8 661 20 61
Fax: (03) 9 650 36 74
> -----Original Message-----
> From: Paul Drake [SMTP:drake_at_psscorp.com]
> Sent: Thursday, September 14, 2000 2:15 PM
> To: Multiple recipients of list ORACLE-L
> 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 Wed Sep 13 2000 - 22:41:10 CDT
