Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    14

    Unanswered: EXP-00008: ORACLE error 904 encountered

    I have a new server running RH 9 with 8.1.7.0.1 on it.

    I try to do a simple full export and I get this

    Export: Release 8.1.7.0.1 - Production on Thu Apr 22 09:42:31 2004

    (c) Copyright 2000 Oracle Corporation. All rights reserved.


    Connected to: Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production
    Enter array fetch buffer size: 4096 >

    Export file: expdat.dmp > exptest.dmp

    (1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 1

    Export grants (yes/no): yes >

    Export table data (yes/no): yes >

    Compress extents (yes/no): yes >

    Export done in US7ASCII character set and US7ASCII NCHAR character set

    About to export the entire database ...
    . exporting tablespace definitions
    . exporting profiles
    . exporting user definitions
    . exporting roles
    . exporting resource costs
    . exporting rollback segment definitions
    EXP-00008: ORACLE error 904 encountered
    ORA-00904: invalid column name
    EXP-00000: Export terminated unsuccessfully

    I have tried running catexp.sql and catalog.sql again to no avail.

  2. #2
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102

    Re: EXP-00008: ORACLE error 904 encountered

    you try to do run the exp-binary version 8.1.7.0.1 again a database version 8.1.6.0.0
    The error might occure, as the exp binary tries to use some objects which are not available in version 8.1.6.
    I'd suggest to try a exp utility version 8.1.6.0.0

    (a highly unsupported way would be to TRY to run catexp.sql of version 8.1.7.0.1 against the database 8.1.6. But if this brakes anything, don't blame anyone)
    ^/\x

  3. #3
    Join Date
    Jun 2003
    Posts
    14
    ok now I have it rolling, but I get the following errors!! Creates the file, is it usable?

    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AQ_SYS_EXP_INTER
    ORA-06552: PL/SQL: Compilation unit analysis terminated
    ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 141
    ORA-06512: at line 1
    EXP-00083: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUES.gra

    EXP-00008: ORACLE error 4045 encountered
    ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AQ_IMPORT_INTERNAL
    ORA-06552: PL/SQL: Compilation unit analysis terminated
    ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at line 1
    ORA-06512: at "SYS.DBMS_SYS_SQL", line 1118
    ORA-06512: at "SYS.DBMS_SQL", line 316
    ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 84
    ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 135
    ORA-06512: at line 1
    EXP-00000: Export terminated unsuccessfully

  4. #4
    Join Date
    Jun 2003
    Posts
    14

    Talking

    I have it all figured out. Rookie DBA never ran catproc.sql

    thanks for reading, hope this helps someone else.

Posting Permissions

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