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 03:46 PM.
Run ORACLE_HOME\rdbms\admin\catexp.sql logged in as SYS and try doing export again. should work.
I found it in metalink. But my db version is 18.104.22.168
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 22.214.171.124
cause: Patchset 126.96.36.199 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 188.8.131.52 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.
Click Here to Expand Forum to Full Width