DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Export Problem

Hybrid View

  1. #1
    Join Date
    May 2001
    Location
    India
    Posts
    55

    Arrow

    Hi,

    Here I am doing Export operation.

    while exporting database, It gives the error message like
    'CLASS oracle/aurora/rdbms/DBMSJAVA' does not exist.

    tables are exporting fine but when starting to export the synonym it gives the error message :

    class oracle/aurora/rdbms/DBMSJAVA dose not exist.

    What I can do please tell me the solution.

    My id is shankar_gk@hotmail.com,shankar_gk@usa.net

    bye,

    G.Shankar.



  2. #2
    Join Date
    Jan 2001
    Posts
    153
    Hi

    this is something i have.....




    Doc ID: Note:1017276.102
    Subject: Oracle8i Export Fails on Synonym Export with EXP-00008 and ORA-00904
    Type: PROBLEM
    Status: PUBLISHED
    Content Type: TEXT/PLAIN
    Creation Date: 28-AUG-1999
    Last Revision Date: 28-JUN-2000


    Problem Description:
    ====================

    You are exporting from Oracle 8.1.5. The export is running smoothly until it
    begins to export the synonyms, then it returns the following:

    . 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" exists without a corresponding package.


    Search Words:
    =============

    export, import, utilities, Oracle8i, 8i, synonym
    EXP-8 ORA-904

    Solution: Create Package "DBMS_JAVA" if Java is Enabled

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

    Run script "$ORACLE_HOME/javavm/install/initdbj.sql" as internal
    in order to create package "DBMS_JAVA", which is required if Java
    is enabled.


    Solution Explanation:
    =====================

    Error is returned because export is executing a select statement
    which uses the procedure "DBMS_JAVA.LONGNAME".

    Using STACKTRACE tracing shows 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

    The error is because the "DBMS_JAVA.LONGNAME" does not exist. Running the
    above script creates the package "DBMS_JAVA" and the "LONGNAME" function.

    Solution: Check for Synonym named DBMS_JAVA or DBMS_JAVA_TEST

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

    Check for synonyms named DBMS_JAVA and DBMS_JAVA_TEST. If there is a synonym
    by either of these names, but there is not a corresponding DBMS_JAVA or
    DBMS_JAVA_TEST package, drop the synonym and rerun the export.


    Solution Explanation:
    =====================

    If Java is enabled, synonyms may have a "long" translation, so export uses a
    special query that invokes the DBMS_JAVA.LONGNAME function ("SELECT ...
    DBMS_JAVA.LONGNAME(SYNNAM) FROM ..."). If the DBMS_JAVA package has not been
    installed, this query will fail with and ORA-00904: "invalid column name".

    In Oracle 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.

    Therefore, this problem will occur if the synonym for DBMS_JAVA exists, but
    there is not a corresponding DBMS_JAVA package.
    Vijay.s

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Solution

    Hi, 19th May 2001 15:26 hrs chennai

    As vijay has said you have to check up them carefully.

    also Look in to this links which stress in detail the dbms_java package info

    http://os.cc.biu.ac.il/documentation...DME_javavm.txt

    http://www.oradoc.com/ora817/java.81...8/03write9.htm

    http://nlhgis.nlh.no/oradoc/java.815...2/04jserve.htm


    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width