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

Thread: invalid column name during export

  1. #1
    Join Date
    Oct 2001
    Posts
    15
    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?

    Shirly

  2. #2
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    shirly,

    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....
    alapps

    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