用drop删除表时,报如下错误:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 19不能删除表,请高手帮忙看看。
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 19不能删除表,请高手帮忙看看。
解决方案 »
- 如何将excel中的数据导入到oracle 数据库中
- oracle几个小问题
- 高分求救:用imp导入数据库出现kgepop: no error frame to pop to for error 21500
- DBMS_OUTPUT.PUT_LINE('ITEM NO ' || TO_CHAR(T_CNT)); 是什么意思
- 关于long数据类型字段的问题,请各位看看
- Oracle9i 会话中的问题
- VB控件为什么不能连ORACLE,在线等,谢谢!
- 为什么我的笔记本上不能安装Oracle?
- help me !!!!!!!!!!!!!!!
- 远程操作如何进行数据库的导入/导出?
- dataguard broker 切换主备库问题
- oracle 自定义分组
SQL> create table f5(id int);Table createdSQL> insert into f5 values(3);1 row insertedSQL> drop table f5;drop table f5ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 19SQL>
--我做了下类似操作 是没有问题的
SQL> create table t2(id number);Table created.SQL> insert into t2 values(1);1 row created.SQL> drop table t2;Table dropped.
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 0 0 0 0Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 265
********************************************************************************BEGIN
BEGIN
IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN
xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
END IF;
EXCEPTION
WHEN OTHERS THEN
null;
END;
BEGIN
IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN
xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);
END IF;
EXCEPTION
WHEN OTHERS THEN
null;
END;
END;call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 1Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 38 (recursive depth: 1)
********************************************************************************SELECT USER_ID
FROM
ALL_USERS WHERE USERNAME = :B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 14 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.00 0.00 0 14 0 2Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 38 (recursive depth: 2)
********************************************************************************select text
from
view$ where rowid=:1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 21 0.00 0.00 0 0 0 0
Execute 21 0.00 0.00 0 0 0 0
Fetch 21 0.00 0.00 0 42 0 21
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 63 0.00 0.00 0 42 0 21Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: SYS (recursive depth: 3)Rows Row Source Operation
------- ---------------------------------------------------
1 TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=32 us)********************************************************************************SELECT /*+ ALL_ROWS */ COUNT(*)
FROM
ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND
(POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$xd_%') AND V.FUNCTION =
:B1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.11 0.10 0 0 0 0
Fetch 2 0.00 0.00 0 108 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.11 0.11 0 108 0 2Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 38 (recursive depth: 2)
********************************************************************************
drop user出现你这个错误的
ORA-00604: error occurred at recursive SQL level 1 .
这样的提示,很多时候是没有丝毫用处的。本案例就这一类问题提供一个思路及方法供大家参考。
1. drop user出现问题
报出以下错误后退出
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist .
关于 recursive SQL 错误我们有必要做个简单说明。
我们知道,当我们发出一条简单的命令以后
Oracle数据库要在后台解析这条命令,并转换为Oracle数据库的一系列后台操作。
这些后台操作统称为递归sql.
比如create table这样一条简单的DDL命令,Oracle数据库在后台,实际上要把这个命令转换为对于obj$,tab$,col$等底层表的插入操作。Oracle所作的工作可能比我们有时候想的要复杂的多。 2.跟踪问题
我们知道Oracle提供sql_trace的功能
可以用于跟踪Oracle数据库的后台递归操作。
通过跟踪文件,我们可以找到问题的所在
以下是格式化(tkprof)后的输出:
The following statement encountered a error during parse:
DELETE FROM SDO_GEOM_METADATA_TABLE WHERE SDO_OWNER = 'WAPCOMM'
Error encountered: ORA-00942Oracle把错误信息首先呈现出来,我们看到ORA-00942错误是由于
SDO_GEOM_METADATA_TABLE表/视图不存在所致,问题由此可以定位。
对于这一类的错误,定位问题以后解决的方法就要依据具体问题原因而定了。 3.问题定位
对于本案例,通过Metalink获得以下解释:
Problem Description
The Oracle Spatial Option has been installed and you are encountering
the following errors while trying to drop a user, who has no spatial tables,
connected as SYSTEM:
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 7
A 942 error trace shows the failing SQL statement as:
DELETE FROM SDO_GEOM_METADATA_TABLE WHERE SDO_OWNER = ''
Solution Description(1)
Create a synonym for SDO_GEOM_METADATA_TABLE under SYSTEM which points to
MDSYS.SDO_GEOM_METADATA_TABLE.
对于本例,为MDSYS.SDO_GEOM_METADATA_TABLE创建一个同义词即可解决,是相对简单的情况。2)
Now the user can be dropped connected as SYSTEM.
Related Documents
ORA-604 and ORA-942 Reported During DROP USER CASCA4.实际处理
MDSYS.SDO_GEOM_METADATA_TABLE为Spatial对象,如果未使用Spatial选项,可以删除SQL> connect / as sysdbaConnected.
SQL> select * from dba_sdo_geom_metadata order by owner;
select * from dba_sdo_geom_metadata order by owner
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-04063: view "MDSYS.DBA_SDO_GEOM_METADATA" has errors
SQL> select object_name from dba_objects where object_name like '%SDO%';
OBJECT_NAME
ALL_SDO_GEOM_METADATA
ALL_SDO_INDEX_INFO
ALL_SDO_INDEX_METADATA
DBA_SDO_GEOM_METADATA
DBA_SDO_INDEX_INFO
DBA_SDO_INDEX_METADATA
....
DBA_SDO_GEOM_METADATA
DBA_SDO_INDEX_INFO
...
SDO_WITHIN_DISTANCE
USER_SDO_GEOM_METADATA
USER_SDO_INDEX_INFO
USER_SDO_INDEX_METADATA
88 rows selected.
SQL> drop user MDSYS cascade;
User dropped.
SQL> select owner,type_name from dba_types where type_name like 'SDO%';
no rows selected
SQL>
SQL> alter session set sql_trace=true;
Session altered.
SQL> drop user wapcomm;
User dropped.
SQL> alter session set sql_trace=false;
Session altered.
SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production这时用户得以顺利drop
5.一点总结使用sql_trace可以跟踪数据库的很多后台操作有利于我们发现问题的所在,很多时候,我们想要研究Oracle的内部活动或后台操作,也可以通过sql_trace跟踪,sql_trace/10046 是Oracle提供的最为有效的诊断工具之一。
有关 ORA-00604 错误的总结
http://blog.csdn.net/tianlesoftware/archive/2009/11/09/4787074.aspx------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
PARSING IN CURSOR #4 len=25 dep=0 uid=265 oct=1 lid=265 tim=19920093376546 hv=3527793709 ad='f34ba280'
create table r2(id int)
END OF STMT
PARSE #4:c=0,e=511,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=19920093376542
=====================
PARSING IN CURSOR #9 len=198 dep=1 uid=0 oct=3 lid=0 tim=19920093377619 hv=4125641360 ad='f3a99ef8'
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
END OF STMT
PARSE #9:c=0,e=780,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093377616
EXEC #9:c=10000,e=1881,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093379726
FETCH #9:c=0,e=54,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=19920093379838
STAT #9 id=1 cnt=0 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 pr=0 pw=0 time=67 us)'
STAT #9 id=2 cnt=0 pid=1 pos=1 obj=37 op='INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=57 us)'
=====================
PARSING IN CURSOR #7 len=198 dep=1 uid=0 oct=3 lid=0 tim=19920093380133 hv=4125641360 ad='f3a99ef8'
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
END OF STMT
EXEC #7:c=0,e=19,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=19920093380130
FETCH #7:c=0,e=21,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,tim=19920093380230
=====================
PARSING IN CURSOR #6 len=116 dep=1 uid=0 oct=3 lid=0 tim=19920093380798 hv=854877822 ad='f3a977d8'
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT
PARSE #6:c=0,e=491,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093380795
EXEC #6:c=0,e=1068,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093382032
FETCH #6:c=0,e=22,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=19920093382107
STAT #6 id=1 cnt=0 pid=0 pos=1 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ (cr=2 pr=0 pw=0 time=28 us)'
STAT #6 id=2 cnt=0 pid=1 pos=1 obj=36 op='INDEX UNIQUE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=24 us)'
=====================
PARSING IN CURSOR #3 len=205 dep=1 uid=0 oct=2 lid=0 tim=19920093382853 hv=3861105107 ad='f3592e98'
insert into obj$(owner#,name,namespace,obj#,type#,ctime,mtime,stime,status,remoteowner,linkname,subname,dataobj#,flags,oid$,spare1,spare2)values(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16, :17)
END OF STMT
PARSE #3:c=0,e=577,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093382850
EXEC #3:c=0,e=1496,p=0,cr=1,cu=7,mis=1,r=1,dep=1,og=4,tim=19920093384595
=====================
PARSING IN CURSOR #8 len=36 dep=1 uid=0 oct=3 lid=0 tim=19920093385141 hv=1570213724 ad='f3a740c8'
select file# from file$ where ts#=:1
END OF STMT
PARSE #8:c=0,e=383,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093385138
EXEC #8:c=0,e=725,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093385974
FETCH #8:c=0,e=68,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=19920093386094
FETCH #8:c=0,e=17,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=19920093386140
STAT #8 id=1 cnt=1 pid=0 pos=1 obj=17 op='TABLE ACCESS FULL FILE$ (cr=4 pr=0 pw=0 time=62 us)'
=====================
PARSING IN CURSOR #9 len=206 dep=1 uid=0 oct=3 lid=0 tim=19920093387146 hv=2888850659 ad='f3a7efd0'
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0) from seg$ where ts#=:1 and file#=:2 and block#=:3
END OF STMT
PARSE #9:c=0,e=665,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093387143
EXEC #9:c=0,e=1504,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093388827
FETCH #9:c=0,e=22,p=0,cr=2,cu=0,mis=0,r=0,dep=1,og=4,tim=19920093388900
STAT #9 id=1 cnt=0 pid=0 pos=1 obj=14 op='TABLE ACCESS CLUSTER SEG$ (cr=2 pr=0 pw=0 time=26 us)'
STAT #9 id=2 cnt=0 pid=1 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 time=21 us)'
=====================
PARSING IN CURSOR #7 len=256 dep=1 uid=0 oct=2 lid=0 tim=19920093389842 hv=2325978899 ad='f358b7a8'
insert into seg$ (file#,block#,type#,ts#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,lists,groups,cachehint,bitmapranges,hwmincr, spare1, scanhint) values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,0,:16,DECODE(:17,0,NULL,:17),:18)
END OF STMT
PARSE #7:c=0,e=612,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093389839
EXEC #7:c=0,e=1474,p=0,cr=3,cu=7,mis=1,r=1,dep=1,og=4,tim=19920093391521
=====================
PARSING IN CURSOR #6 len=103 dep=1 uid=0 oct=6 lid=0 tim=19920093392214 hv=3840466760 ad='f358b208'
update tsq$ set blocks=:3,maxblocks=:4,grantor#=:5,priv1=:6,priv2=:7,priv3=:8 where ts#=:1 and user#=:2
END OF STMT
PARSE #6:c=0,e=592,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093392211
EXEC #6:c=10000,e=1577,p=0,cr=4,cu=1,mis=1,r=1,dep=1,og=4,tim=19920093393935
STAT #6 id=1 cnt=0 pid=0 pos=1 obj=0 op='UPDATE TSQ$ (cr=4 pr=0 pw=0 time=356 us)'
STAT #6 id=2 cnt=1 pid=1 pos=1 obj=61 op='TABLE ACCESS CLUSTER TSQ$ (cr=4 pr=0 pw=0 time=168 us)'
STAT #6 id=3 cnt=1 pid=2 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=1 pr=0 pw=0 time=18 us)'
=====================
PARSING IN CURSOR #7 len=494 dep=1 uid=0 oct=2 lid=0 tim=19920093395214 hv=2283232350 ad='f358a170'
insert into tab$(obj#,ts#,file#,block#,bobj#,tab#,intcols,kernelcols,clucols,audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,analyzetime,samplesize,cols,property,degree,instances,dataobj#,avgspc_flb,flbcnt,trigflag,spare1,spare6)values(:1,:2,:3,:4,decode(:5,0,null,:5),decode(:6,0,null,:6),:7,:8,decode(:9,0,null,:9),:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,decode(:26,1,null,:26),decode(:27,1,null,:27),:28,:29,:30,:31,:32,:33)
END OF STMT
PARSE #7:c=0,e=893,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093395211
=====================
PARSING IN CURSOR #6 len=36 dep=2 uid=0 oct=3 lid=0 tim=19920093397459 hv=1570213724 ad='f3a740c8'
select file# from file$ where ts#=:1
END OF STMT
PARSE #6:c=0,e=49,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=19920093397455
EXEC #6:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=19920093397620
FETCH #6:c=0,e=46,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=19920093397696
FETCH #6:c=0,e=8,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=19920093397734
STAT #6 id=1 cnt=1 pid=0 pos=1 obj=17 op='TABLE ACCESS FULL FILE$ (cr=4 pr=0 pw=0 time=44 us)'
EXEC #7:c=0,e=2725,p=1,cr=10,cu=16,mis=1,r=1,dep=1,og=4,tim=19920093398372
=====================
PARSING IN CURSOR #8 len=453 dep=1 uid=0 oct=2 lid=0 tim=19920093399301 hv=224718466 ad='f3589ad0'
insert into col$(obj#,name,intcol#,segcol#,type#,length,precision#,scale,null$,offset,fixedstorage,segcollength,deflength,default$,col#,property,charsetid,charsetform,spare1,spare2,spare3)values(:1,:2,:3,:4,:5,:6,decode(:5,182/*DTYIYM*/,:7,183/*DTYIDS*/,:7,decode(:7,0,null,:7)),decode(:5,2,decode(:8,-127/*MAXSB1MINAL*/,null,:8),178,:8,179,:8,180,:8,181,:8,182,:8,183,:8,231,:8,null),:9,0,:10,:11,decode(:12,0,null,:12),:13,:14,:15,:16,:17,:18,:19,:20)
END OF STMT
PARSE #8:c=0,e=805,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093399298
EXEC #8:c=0,e=2021,p=0,cr=2,cu=8,mis=1,r=1,dep=1,og=4,tim=19920093401608
=====================
PARSING IN CURSOR #9 len=150 dep=1 uid=0 oct=3 lid=0 tim=19920093402097 hv=3988833529 ad='f35892b0'
select 1 from sys.streams$_prepare_ddl p where ((p.global_flag = 1 and :1 is null) or (p.global_flag = 0 and p.usrid = :2)) and rownum = 1
END OF STMT
PARSE #9:c=0,e=304,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093402093
EXEC #9:c=0,e=951,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093403130
FETCH #9:c=0,e=21,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,tim=19920093403188
STAT #9 id=1 cnt=0 pid=0 pos=1 obj=0 op='COUNT STOPKEY (cr=1 pr=0 pw=0 time=24 us)'
STAT #9 id=2 cnt=0 pid=1 pos=1 obj=624 op='INDEX FULL SCAN I_STREAMS_PREPARE_DDL (cr=1 pr=0 pw=0 time=21 us)'
XCTEND rlbk=0, rd_only=0
=====================
PARSING IN CURSOR #6 len=296 dep=1 uid=0 oct=6 lid=0 tim=19920093404065 hv=2379717279 ad='f35877c0'
update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17,0,NULL,:17),scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
END OF STMT
PARSE #6:c=0,e=664,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=19920093404061
EXEC #6:c=0,e=1942,p=0,cr=5,cu=1,mis=1,r=1,dep=1,og=4,tim=19920093406208
STAT #6 id=1 cnt=0 pid=0 pos=1 obj=0 op='UPDATE SEG$ (cr=5 pr=0 pw=0 time=320 us)'
STAT #6 id=2 cnt=1 pid=1 pos=1 obj=14 op='TABLE ACCESS CLUSTER SEG$ (cr=5 pr=0 pw=0 time=160 us)'
STAT #6 id=3 cnt=1 pid=2 pos=1 obj=9 op='INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 time=18 us)'
EXEC #4:c=20000,e=29855,p=1,cr=41,cu=53,mis=0,r=0,dep=0,og=1,tim=19920093406472
=====================
PARSING IN CURSOR #7 len=61 dep=0 uid=265 oct=47 lid=265 tim=19920093417925 hv=356401299 ad='f359adf8'
begin :id := sys.dbms_transaction.local_transaction_id; end;
END OF STMT
PARSE #7:c=0,e=41,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=19920093417920
EXEC #7:c=0,e=76,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=19920093418103
=====================
PARSING IN CURSOR #8 len=21 dep=0 uid=265 oct=3 lid=265 tim=19920100448061 hv=2564406738 ad='f35872e0'
select 'x' from dual
END OF STMT
PARSE #8:c=0,e=154,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=19920100448054
EXEC #8:c=0,e=50,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=19920100448221
FETCH #8:c=0,e=27,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=19920100451534
STAT #8 id=1 cnt=1 pid=0 pos=1 obj=0 op='FAST DUAL (cr=0 pr=0 pw=0 time=5 us)'
=====================
PARSING IN CURSOR #3 len=61 dep=0 uid=265 oct=47 lid=265 tim=19920100458973 hv=356401299 ad='f359adf8'
begin :id := sys.dbms_transaction.local_transaction_id; end;
END OF STMT
PARSE #3:c=0,e=50,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=19920100458970
EXEC #3:c=0,e=148,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=19920100459216
XCTEND rlbk=0, rd_only=1
=====================
PARSING IN CURSOR #9 len=15 dep=0 uid=265 oct=12 lid=265 tim=19920100462988 hv=0 ad='1055fc08'
drop table r2
END OF STMT
PARSE #9:c=0,e=430,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=19920100462985
=====================
PARSING IN CURSOR #6 len=652 dep=1 uid=38 oct=47 lid=38 tim=19920100463414 hv=3055982128 ad='f3583b58'
BEGIN
BEGIN
IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN
xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
END IF;
EXCEPTION
WHEN OTHERS THEN
null;
END;
BEGIN
IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN
xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);
END IF;
EXCEPTION
WHEN OTHERS THEN
null;
END;
END;
END OF STMT
PARSE #6:c=0,e=193,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=19920100463411
=====================
PARSING IN CURSOR #5 len=51 dep=2 uid=38 oct=3 lid=38 tim=19920100463831 hv=397653107 ad='f357d478'
SELECT USER_ID FROM ALL_USERS WHERE USERNAME = :B1
END OF STMT
EXEC #5:c=0,e=49,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=19920100463827
FETCH #5:c=0,e=127,p=0,cr=7,cu=0,mis=0,r=1,dep=2,og=1,tim=19920100464036
=====================
PARSING IN CURSOR #1 len=187 dep=2 uid=38 oct=3 lid=38 tim=19920100464306 hv=2673022821 ad='f357d958'
SELECT /*+ ALL_ROWS */ COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND (POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$xd_%') AND V.FUNCTION = :B1
END OF STMT
EXEC #1:c=0,e=189,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=19920100464302
FETCH #1:c=0,e=802,p=0,cr=85,cu=0,mis=0,r=1,dep=2,og=1,tim=19920100465180
=====================
PARSING IN CURSOR #7 len=37 dep=3 uid=0 oct=3 lid=0 tim=19920100466407 hv=1398610540 ad='f3a7c760'
select text from view$ where rowid=:1
END OF STMT
PARSE #7:c=0,e=542,p=0,cr=0,cu=0,mis=1,r=0,dep=3,og=4,tim=19920100466404
EXEC #7:c=0,e=1130,p=0,cr=0,cu=0,mis=1,r=0,dep=3,og=4,tim=19920100467661
FETCH #7:c=0,e=35,p=0,cr=2,cu=0,mis=0,r=1,dep=3,og=4,tim=19920100467751
STAT #7 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=25 us)'
=====================
PARSING IN CURSOR #8 len=37 dep=3 uid=0 oct=3 lid=0 tim=19920100468145 hv=1398610540 ad='f3a7c760'
select text from view$ where rowid=:1
END OF STMT
PARSE #8:c=0,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=19920100468143
EXEC #8:c=0,e=20,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=19920100468269
FETCH #8:c=0,e=20,p=0,cr=2,cu=0,mis=0,r=1,dep=3,og=4,tim=19920100468318
STAT #8 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=14 us)'
=====================
PARSING IN CURSOR #4 len=173 dep=2 uid=265 oct=3 lid=265 tim=19920100469595 hv=2978679347 ad='f35755f8'
SELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPF'
END OF STMT
PARSE #4:c=10000,e=4230,p=0,cr=4,cu=0,mis=1,r=0,dep=2,og=1,tim=19920100469591
=====================
PARSING IN CURSOR #3 len=37 dep=3 uid=0 oct=3 lid=0 tim=19920100470198 hv=1398610540 ad='f3a7c760'
select text from view$ where rowid=:1
END OF STMT
PARSE #3:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=19920100470194
EXEC #3:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=19920100470328
FETCH #3:c=0,e=26,p=0,cr=2,cu=0,mis=0,r=1,dep=3,og=4,tim=19920100470383
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=19 us)'
=====================
PARSING IN CURSOR #7 len=37 dep=3 uid=0 oct=3 lid=0 tim=19920100470716 hv=1398610540 ad='f3a7c760'
select text from view$ where rowid=:1
END OF STMT
PARSE #7:c=0,e=15,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=19920100470714
EXEC #7:c=0,e=17,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=19920100470831
FETCH #7:c=0,e=16,p=0,cr=2,cu=0,mis=0,r=1,dep=3,og=4,tim=19920100470876
STAT #7 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=10 us)'
EXEC #4:c=0,e=3874,p=0,cr=4,cu=0,mis=1,r=0,dep=2,og=1,tim=19920100473723
FETCH #4:c=0,e=190,p=0,cr=23,cu=0,mis=0,r=1,dep=2,og=1,tim=19920100473989
STAT #4 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=23 pr=0 pw=0 time=213 us)'
STAT #4 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS (cr=23 pr=0 pw=0 time=203 us)'
STAT #4 id=3 cnt=8 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=5 pr=0 pw=0 time=119 us)'
STAT #4 id=4 cnt=1 pid=3 pos=1 obj=22 op='TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=42 us)'
STAT #4 id=5 cnt=1 pid=4 pos=1 obj=44 op='INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=28 us)'
STAT #4 id=6 cnt=8 pid=3 pos=2 obj=438 op='TABLE ACCESS FULL RLS$ (cr=3 pr=0 pw=0 time=61 us)'
STAT #4 id=7 cnt=0 pid=2 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ (cr=18 pr=0 pw=0 time=82 us)'
STAT #4 id=8 cnt=8 pid=7 pos=1 obj=36 op='INDEX UNIQUE SCAN I_OBJ1 (cr=10 pr=0 pw=0 time=48 us)'
EXEC #5:c=0,e=24,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=19920100474304
FETCH #5:c=0,e=42,p=0,cr=7,cu=0,mis=0,r=1,dep=2,og=1,tim=19920100474370
EXEC #1:c=0,e=77,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=19920100474497
FETCH #1:c=0,e=324,p=0,cr=23,cu=0,mis=0,r=1,dep=2,og=1,tim=19920100474846
=====================
PARSING IN CURSOR #3 len=37 dep=3 uid=0 oct=3 lid=0 tim=19920100475345 hv=1398610540 ad='f3a7c760'
select text from view$ where rowid=:1
END OF STMT
PARSE #3:c=0,e=17,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=19920100475341
EXEC #3:c=0,e=25,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=19920100475477
FETCH #3:c=0,e=24,p=0,cr=2,cu=0,mis=0,r=1,dep=3,og=4,tim=19920100475530
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=16 us)'
=====================
PARSING IN CURSOR #7 len=37 dep=3 uid=0 oct=3 lid=0 tim=19920100475845 hv=1398610540 ad='f3a7c760'
select text from view$ where rowid=:1
END OF STMT
PARSE #7:c=0,e=14,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=19920100475843
EXEC #7:c=0,e=18,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=19920100475960
FETCH #7:c=0,e=17,p=0,cr=2,cu=0,mis=0,r=1,dep=3,og=4,tim=19920100476006
STAT #7 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=10 us)'
=====================
PARSING IN CURSOR #8 len=176 dep=2 uid=265 oct=3 lid=265 tim=19920100477140 hv=3744356981 ad='f3573db0'
SELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPROPF'
END OF STMT
PARSE #8:c=0,e=2188,p=0,cr=4,cu=0,mis=1,r=0,dep=2,og=1,tim=19920100477137
=====================
PARSING IN CURSOR #4 len=37 dep=3 uid=0 oct=3 lid=0 tim=19920100477687 hv=1398610540 ad='f3a7c760'
select text from view$ where rowid=:1
END OF STMT
PARSE #4:c=0,e=15,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=19920100477683
EXEC #4:c=0,e=26,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=19920100477813
FETCH #4:c=0,e=25,p=0,cr=2,cu=0,mis=0,r=1,dep=3,og=4,tim=19920100477866
STAT #4 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=18 us)'
=====================
PARSING IN CURSOR #3 len=37 dep=3 uid=0 oct=3 lid=0 tim=19920100478185 hv=1398610540 ad='f3a7c760'
select text from view$ where rowid=:1
END OF STMT