Re: HELP: Export - EXP-00008: ORACLE error 904 encountered NT4

Hi.

thanks for the advice.
I did re-run catexp.sql right after I spotted the error. Same result. Opened an iTAR. Metalink was slow at 11 PM EST.

I thought about running catalog, catproc and catexp, figured that I'd wait to hear from Oracle Support in the morning. Caught Sting at Central Park last night, and I could use some sleep.

DB was built in 8.1.6.0.0 - imported from 7.3.4.5.2 export. created in June, patched in late august to 8.1.6.1.1, then 8.1.6.1.2. 8.1.6.1.2 patch applied by home grown scripts (no installer) - I'm sure that those worked correctly from the log.

I'm not sure how long the EXP-00008 error has been occurring. 2 Worst case scenarios:

• create a new 8.1.6.0.0 instance, export database with catexp7.sql and import that dump
• create a new 8.1.6.0.0 instance, script a CTAS with dblinks. Move all data, then build indexes, constraints.

[plug]Might be a good time to try PDQOUT?[/plug]

Paul

"Afanassiev, Alex" wrote:

> 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).
> --
> Author: Afanassiev, Alex
> INET: Alex.Afanassiev_at_team.telstra.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
Received on Thu Sep 14 2000 - 01:07:14 CDT