invalid column name during export Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: invalid column name during export

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Has anyone encountered this. I tried to export my development schema and receive an "invalid column name" error. It backs up all the tables, then I receive the error.

    . . exporting table W_TERR 3 rows exported
    . exporting synonyms
    EXP-00008: ORACLE error 904 encountered
    ORA-00904: invalid column name
    EXP-00000: Export terminated unsuccessfully

    Any suggestions on how to correct this?


  2. #2
    Join Date
    Jul 2002

    Have you recently applied a patch to your database?...
    This usually occurs after a patch has been applied and the DBA (We've all been there) has not run catalog.sql and catproc.sql.

    1. Logon to sqlplus as SYS
    2. run catalog.sql & catproc.sql from $ORACLE_HOME/rdbms/admin.

    This should fix the situation....

    Fast, Cheap, Reliable... Pick Two(2)

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