Re: Resolved - Export - EXP-00008: ORA-00904 encountered NT4 8.1.6

From: Paul Drake <paled_at_home.com>
Date: Fri, 15 Sep 2000 02:09:21 -0400
Message-Id: <10619.117065@fatcity.com>

Hi Allan,

It turns out that this was a problem entirely relating to installing more options that will be used at the current time. Oracle 8.1.6.1.2 on WinNT.
JServer was installed. Oops.

Oracle Support was right on this one and came up with:

  Title: Oracle8i Export Fails on Synonym Export with EXP-00008 and   ORA-00904
  Open-Remarks: See <RemarksOn:NOTE:1017276.102>   Document-Type: PROBLEM
  Impact: LOW
  Skill-Level: CASUAL
  Server-Version: XX
  Updated-Date: 28-JUN-2000 10:49:53
  References:
  Shared-Refs:
  <SOLUTION:2064570.102>Check for Synonym named DBMS_JAVA or DBMS_JAVA_TEST   <SOLUTION:98463.1> Create Package "DBMS_JAVA" if Java is Enabled   Authors: MSHART.US
  Attachments: NONE
  Content-Type: TEXT/PLAIN
  Keywords: EXPORTINFO;
  Errors: EXP-00008; ORA-00904;
  Products: 5/EXP (8.1);
  Platforms: GENERIC;

Dropping the synonyms was not sufficient, so I re-created the java system.

The fix was this:

crank java shared pool up to ^ 64 MB in the init file

@catalog,
@catproc,
@catexp

create or replace java system,
shutdown
in the init file - reduce java shared pool V 8 MB

Export now works like always.
Better off to have never installed Java. I'll blame it on reading Oracle Magazine's article on SQLJ earlier that weed. Someday, I'll use java. For now, I'll go with what I know, er, with what I can find and borrow on the dba links sites.

Paul

Allan Nelson wrote:

> 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 -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, September 13, 2000 10:15 PM
>
> > 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: Allan Nelson
> INET: anelson_at_houston.rr.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 Fri Sep 15 2000 - 01:09:21 CDT