Extremely Urgent -- Import Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Extremely Urgent -- Import Error

  1. #1
    Join Date
    Feb 2003
    Posts
    67

    Extremely Urgent -- export Error

    I am getting this error on a 9.2 database export. I ran catalog and catproc to make sure that the export utilities are valid... The exp is from the 9.2 bin... I get this error with FULL OR USER level export...

    . exporting synonyms
    . exporting views
    EXP-00056: ORACLE error 904 encountered
    ORA-00904: "UNDERCLAUSE": invalid identifier
    EXP-00000: Export terminated unsuccessfully

    I need this file before the end of the day... It is happening on a 31 gig database that has all the tables exported.. and it is happening at views...
    Last edited by sureshot; 08-22-2003 at 04:46 PM.

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Run ORACLE_HOME\rdbms\admin\catexp.sql logged in as SYS and try doing export again. should work.
    -- Dilip

  3. #3
    Join Date
    Feb 2003
    Posts
    67
    I found it in metalink. But my db version is 9.2.0.1

    -------------------------------------------------------
    fact: Oracle Server - Enterprise Edition
    fact: Export Utility (EXP)
    symptom: Unable to export view
    symptom: EXP-00056: placeholder for OCI error
    symptom: ORA-00904: %s: invalid identifier
    symptom: "UNDERCLAUSE": invalid identifier
    symptom: EXP-00000: Export terminated unsuccessfully
    symptom: Export was possible before patch installation
    change: Applied patchset 9.2.0.2
    cause: Patchset 9.2.0.2 and higher introduces two new columns UNDERLEN and
    UNDERCLAUSE in the view sys.exu8vew. This modified view is created by executing
    the script catexp.sql which is called automatically when executing the script
    catalog.sql (part of the patchset installation procedure).
    The columns UNDERLEN and UNDERCLAUSE are used by the Export utility 9.2.0.2 and
    higher. If the view sys.exu8vew does not contain the columns UNDERLEN and
    UNDERCLAUSE, the RDBMS will report ORA-904 "Invalid Identifier"
    (formerly: "Invalid Column name") and the export will abort with EXP-
    0 when trying to export views.

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