Export Fails With ORA-00904 After Upgrade
(Doc ID 332178.1)
Last updated on MAY 19, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.7.4 and laterInformation in this document applies to any platform.
Symptoms
+ Upgraded the database from 8.1.7 to 8.1.7.4.1.
+ Export fails with the below error:
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully
+ 904 event trace file shows the below sql
ORA-00904: invalid column name
Current SQL statement for this session:
SELECT GRANTOR, GRANTORID, GRANTEE, PRIV, WGO, ISDIR, TYPE
FROM SYS.EXU8GRN WHERE OBJID = :1 ORDER BY WGO DESC, SEQUENCE
select owner,object_name,object_type,object_id,status
from dba_objects
where object_name='EXU8GRN';
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |