2.再次执行exp
3.alter system set events '904 trace name context off';
4.查看生成的trace文件：
/home/oracle/data/app/oracle/admin/cicgo/udump/ora_5579.trc
Oracle8i Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production
ORACLE_HOME = /home/oracle/data/app/oracle/product/8.1.7/
System name: Linux
Node name: cicgo1
Release: 2.4.18-3
Version: #1 Thu Apr 18 07:37:53 EDT 2002
Machine: i686
Instance name: cicgo
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 5579, image: oracle@cicgo1 (TNS V1-V3)
*** SESSION ID:(14.23243) 2013-04-24 09:31:40.273
*** 2013-04-24 09:31:40.273
ksedmp: internal or fatal error
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
Please try below:
1. svrmgrl
svrmgrl>connect internal
svrmgrl>@catexp.sql
svrmgrl>CREATE OR REPLACE view exu8grn (objid, grantor, grantorid, grantee,
priv, wgo,
creatorid, sequence, isdir, type) AS
SELECT t$.obj#, ur$.name, t$.grantor#, ue$.name,
m$.name, NVL(t$.option$,0), o$.owner#, t$.sequence#,
DECODE ( (o$.type#), 23, 1, 0 ), /* flag if directory alias */
o$.type#
FROM sys.objauth$ t$, sys.obj$ o$, sys.user$ ur$,
sys.table_privilege_map m$, sys.user$ ue$
WHERE o$.obj# = t$.obj# AND t$.privilege# = m$.privilege AND
t$.col# IS NULL AND t$.grantor# = ur$.user# AND
t$.grantee# = ue$.user# AND
ue$.name not in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS',
'LBACSYS')
/
grant select on exu8grn to select_catalog_role
/
再次运行exp时可以成功导出。