环境:aix 6.1 oracle:10.2.0.5 RAC
打开跟踪
SQL> alter system set events '22923 trace name errorstack level 3';
expdp
生成的文件名在
cd $ORACLE_BASE/admin/bdump/
sid_dm_processid.trc
取消跟踪
SQL> alter system set events '22923 trace name errorstack off';
找出语句：
select sys_xml_gen(value(ku$),xmlformat.createformat2('PAKAGE_BODY_T','7'))) from sys.ku$_exp_pkg_obdy_view ku$ where
ku$.base_obj_num in (select * from table(dbms_metadata.fetch_objnums(200001))
定位到具体的obj_Num 50142
补充说明一下：
base_obj_num oracle定义的object type:
CREATE OR REPLACE VIEW SYS.KU$_EXP_PKG_BODY_VIEW OF ku$_exp_pkg_body_t WITH OBJECT OID (obj_num)