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

Thread: Export Error

  1. #1
    Join Date
    Aug 2002
    Posts
    176

    Export Error

    Hi

    When I run an export it displays the following error in the log


    ************************
    Connected to: Oracle8i Release 8.1.7.4.0 - Production
    JServer Release 8.1.7.4.0 - Production
    Export done in US7ASCII character set and US7ASCII NCHAR character set

    About to export specified tables via Conventional Path ...
    . . exporting table PERSON 1063913 rows exported
    EXP-00008: ORACLE error 904 encountered
    ORA-00904: invalid column name
    . . exporting table CUSTUSAGE 1026906 rows exported
    EXP-00008: ORACLE error 1003 encountered
    ORA-01003: no statement parsed
    . . exporting table CUSTINFO 1034798 rows exported
    EXP-00008: ORACLE error 904 encountered
    ORA-00904: invalid column name
    . . exporting table UNAMES_TRAN 2282836 rows exported
    EXP-00008: ORACLE error 1003 encountered
    ORA-01003: no statement parsed
    . . exporting table RENEWHISTORY 180117 rows exported
    EXP-00008: ORACLE error 904 encountered
    ORA-00904: invalid column name
    . . exporting table RENEWBACKUP 617254 rows exported
    EXP-00008: ORACLE error 1003 encountered
    ORA-01003: no statement parsed
    . . exporting table NASLOCATION 198 rows exported
    EXP-00008: ORACLE error 904 encountered
    ORA-00904: invalid column name
    . . exporting table RENEWALREQUEST 197015 rows exported
    EXP-00003: no storage definition found for segment(13, 116233)
    . . exporting table ORDERDESPATCH 178788 rows exported
    Export terminated successfully with warnings.

    *********************************

    but the table structure is OK
    SQL> desc CUSTINFO
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    CUSTID NOT NULL NUMBER(32)
    LOGINNAME NOT NULL VARCHAR2(32)
    PRODCODE VARCHAR2(8)
    SERVICEEND DATE
    REMINDFLG DATE
    EXPFLG VARCHAR2(2)
    SUSPENDDT DATE



    Why does it display the error Invalid column name and no statement parsed.

    Oracle 8.1.7 on Sun OS

    Thanks
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  2. #2
    Join Date
    Aug 2002
    Posts
    115

    Found this in a diff forum...might be helpful

    How to handle ORA-00904 errors on Export

    When running full database export the following errors will be returned:

    exp80 user/password full=y file=D:\DB-Backup\ORCL\expORCL.dmp log=D:\DB-Backup\ORCL\expORCL.log consistent=y buffer=40960000

    EXP-00008: ORACLE error 904 encountered
    ORA-00904: invalid column name


    To get a clue what has force these ORA-00904 message, follow the following
    steps:

    1. Connect as privileged user and run the following command inside an
    SQLPLUS session:

    SQL> alter system set events='904 trace name errorstack';

    -------------------------------- Note ------------------------------------

    This event will work starting with Oracle8i. If running a Oracle database
    version below Oracle8i, you'll get ORA-02065 errors returned, when
    specifying this event. In Oracle versions below 8i you'll have to insert
    the following entry into INIT.ORA

    event="904 trace name errorstack"

    --------------------------------------------------------------------------

    2. Retry the FULL export. When the ORA-00904 occurs, a trace file will be
    written to the storage location specified by the INIT.ORA parameter
    'user_dump_dest'. As soon as the ORA-00904 has been returned to your
    export session, you can abort the export and examine the trace information.

    3. Disable event tracing by running the following command:

    SQL> alter system set events='904 trace name errorstack off';

    On Oracle versions below 8.1.5 return the event entry from INIT.ORA

    4. Examine the trace file:

    *** SESSION ID:(9.3) 2001.11.21.15.28.00.494
    *** 2001.11.21.15.28.00.494
    ksedmp: internal or fatal error
    ORA-00904: invalid column name
    Current SQL statement for this session:
    SELECT fname,fsize,maxextend,inc FROM sys.exu8fil WHERE tsid = :1
    ===========

    a) a problem with object EXU8FIL has been detected
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    In this example, there's a problem with the EXE8FIL view. To examine,
    whether this object exist, run the following command:

    SQL> select owner,object_name,object_type,object_id,status
    from dba_objects
    where object_name='EXU8FIL';

    If the problem is on the EXU8FIL object you simply can recreate the
    object by running the CATEXP.SQL script.

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