Solved

EXP-00008: ORACLE error 904 encountered

Posted on 2002-06-26
3
14,100 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

690 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