Solved

EXP-00008: ORACLE error 904 encountered

Posted on 2002-06-26
3
14,073 Views
Last Modified: 2011-08-18
Dear Experts,
I am getting the following error while using the export utility in the Oracle database 8.1.7.
I have run the catexp.sql and catrm.sql suggested by the experts in this forum. But it did not help me. Kindly help me in solving this issue.

...exporting synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully.......

Thanks and Regards

0
Comment
Question by:Ambience
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 6

Expert Comment

by:M-Ali
ID: 7110361
Have you applied any patches? or upgraded the database? Usually you get this error when the catalog scripts are not run properly.

Log in as sys/internal and run catexp.sql

If still doesnt work try running catrm.sql and initdbj.sql

HTH

Ali
0
 
LVL 3

Accepted Solution

by:
p_yaroslav earned 100 total points
ID: 7110522
Hi!

May be it helps:
________________________________________________
Problem Description:
====================
 
The following is being seen when exporting from Oracle 8.1.x

    . exporting referential integrity constraints
    . exporting synonyms
    EXP-00008: ORACLE error 904 encountered
    ORA-00904: invalid column name
    EXP-00000: Export terminated unsuccessfully

Running "catexp.sql" does not alleviate the problem.

 
Problem Explanation:
====================

A synonym named "DBMS_JAVA" or "DBMS_JAVA_TEST" may exist without a corresponding package.

 
Solution Explanation:
=====================
 
If Java is enabled, export uses DBMS_JAVA.LONGNAME in a query while exporting synonyms.
If the DBMS_JAVA or DBMS_JAVA_TEST package
has not been installed, this query will fail with and ORA-00904: "invalid column name".

In 8.1.5, the Export utility tests if Java is enabled by looking for the synonym
"DBMS_JAVA"; if it exists, Oracle assumes Java is enabled; if it
doesn't, Oracle assumes Java is not enabled.
In 8.1.6, the Export utility tests if java is enabled by looking for java class "/oracle/aurora/rdbms/DbmsJava"

Using STACKTRACE tracing will show the select statement using the "LONGNAME"
function

ksedmp: internal or fatal error
ORA-00904: invalid column name
Current SQL statement for this session:
SELECT SYNNAM, DBMS_JAVA.LONGNAME(SYNNAM), DBMS_JAVA.LONGNAME(SYNTAB)
,TABOWN,TABNODE, PUBLIC$, SYNOWN, SYNOWNID, SYNTIME
FROM SYS.EXU8SYN
WHERE SYNOWNID=:1
ORDER BY SYNTIME


Solution Description:
=====================

If Java is enabled, ensure that both DBMS_JAVA synonyms and packages are created and valid. The following script can be used to
create the required packages, "$ORACLE_HOME/javavm/install/initdbj.sql". This will need to be run as internal.

If Java is disabled, run "$ORACLE_HOME/javavm/install/rmjvm.sql" to remove java related objects. Do not just drop the synonym.


--------------------------------------------------------------------------------
 
 Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use.
________________


Yaroslav.
0
 

Author Comment

by:Ambience
ID: 7112799
Great It helped and solved my problem..

Thanks alot
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Can i Import Access Table Into Oracle Using Toad 36 279
oracle RMAN - trying to duplicate a database 5 52
Repeat query 13 74
DECLARATION OF CURSOR IS INCOMPLETE OR MALFORMED 5 46
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question