SQL> variable c clob SQL> begin 2 dbms_utility.expand_sql_text 3 ( 'select * from LOOKS_SO_INNOCENT',:c); 4 end; 5 / PL/SQL procedure successfully completed. SQL> print c C -------------------------------------------------------------------------------- select "A1"."OWNER" "OWNER", "A1"."CREATED" "CREATED", "A1"."BYTES" "BYTES", "A1"."TABLESPACE_NAME" "TABLESPACE_NAME" from ( select "A2"."OWNER" "OWNER", "A2"."CREATED" "CREATED", "A3"."BYTES" "BYTES", "A3"."TABLESPACE_NAME" "TABLESPACE_NAME" from ( select "A4"."OWNER" "OWNER", "A4"."SEGMENT_NAME" "SEGMENT_NAME", "A4"."PARTITION_NAME" "PARTITION_NAME", "A4"."SEGMENT_TYPE" "SEGMENT_TYPE", "A4"."SEGMENT_SUBTYPE" "SEGMENT_SUBTYPE", "A4"."TABLESPACE_NAME" "TABLESPACE_NAME", "A4"."HEADER_FILE" "HEADER_FILE", "A4"."HEADER_BLOCK" "HEADER_BLOCK", decode(bitand("A4"."SEGMENT_FLAGS",131072),131072,"A4"."BLOCKS",decode(bitand("A4"."SEGMENT_FLAGS",1),1,"SYS"."DBMS_SPACE_ADMIN" ."SEGMENT_NUMBER_BLOCKS"("A4"."TABLESPACE_ID","A4"."RELATIVE_FNO","A4"."HEADER_BLOCK","A4"."SEGMENT_TYPE_ID","A4"."BUFFER_POOL_ID" ,"A4"."SEGMENT_FLAGS","A4"."SEGMENT_OBJD","A4"."BLOCKS"),"A4"."BLOCKS"))* "A4"."BLOCKSIZE" "BYTES", decode(bitand("A4"."SEGMENT_FLAGS",131072),131072,"A4"."BLOCKS",decode(bitand("A4"."SEGMENT_FLAGS",1),1,"SYS"."DBMS_SPACE_ADMIN" ."SEGMENT_NUMBER_BLOCKS"("A4"."TABLESPACE_ID","A4"."RELATIVE_FNO","A4"."HEADER_BLOCK","A4"."SEGMENT_TYPE_ID","A4"."BUFFER_POOL_ID" ,"A4"."SEGMENT_FLAGS","A4"."SEGMENT_OBJD","A4"."BLOCKS"),"A4"."BLOCKS"))"BLOCKS", decode(bitand("A4"."SEGMENT_FLAGS",131072),131072,"A4"."EXTENTS",decode(bitand("A4"."SEGMENT_FLAGS",1),1,"SYS"."DBMS_SPACE_ADMIN" ."SEGMENT_NUMBER_EXTENTS"("A4"."TABLESPACE_ID","A4"."RELATIVE_FNO","A4"."HEADER_BLOCK","A4"."SEGMENT_TYPE_ID","A4"."BUFFER_POOL_ID" ,"A4"."SEGMENT_FLAGS","A4"."SEGMENT_OBJD","A4"."EXTENTS"),"A4"."EXTENTS"))"EXTENTS", "A4"."INITIAL_EXTENT" "INITIAL_EXTENT", "A4"."NEXT_EXTENT" "NEXT_EXTENT", "A4"."MIN_EXTENTS" "MIN_EXTENTS", "A4"."MAX_EXTENTS" "MAX_EXTENTS", "A4"."MAX_SIZE" "MAX_SIZE", "A4"."RETENTION" "RETENTION", "A4"."MINRETENTION" "MINRETENTION", "A4"."PCT_INCREASE" "PCT_INCREASE", "A4"."FREELISTS" "FREELISTS", "A4"."FREELIST_GROUPS" "FREELIST_GROUPS", "A4"."RELATIVE_FNO" "RELATIVE_FNO", decode("A4"."BUFFER_POOL_ID",1,'KEEP',2,'RECYCLE','DEFAULT')"BUFFER_POOL", decode("A4"."FLASH_CACHE",1,'KEEP',2,'NONE','DEFAULT')"FLASH_CACHE", decode("A4"."CELL_FLASH_CACHE",1,'KEEP',2,'NONE','DEFAULT')"CELL_FLASH_CACHE", decode(bitand("A4"."SEGMENT_FLAGS",4294967296),4294967296,'ENABLED','DISABLED')"INMEMORY", decode(bitand("A4"."SEGMENT_FLAGS",4294967296),4294967296,decode(bitand("A4"."SEGMENT_FLAGS",34359738368),34359738368,decode (bitand("A4"."SEGMENT_FLAGS",61572651155456),8796093022208,'LOW',17592186044416,'MEDIUM',35184372088832,'HIGH',52776558133248 ,'CRITICAL','NONE'),'NONE'),null)"INMEMORY_PRIORITY", decode(bitand("A4"."SEGMENT_FLAGS",4294967296),4294967296,decode(bitand("A4"."SEGMENT_FLAGS",8589934592),8589934592,decode (bitand("A4"."SEGMENT_FLAGS",206158430208),68719476736,'BY ROWID RANGE',137438953472,'BY PARTITION',206158430208,'BY SUBPARTITION' ,0,'AUTO'),'UNKNOWN'),null)"INMEMORY_DISTRIBUTE", decode(bitand("A4"."SEGMENT_FLAGS",4294967296),4294967296,decode(bitand("A4"."SEGMENT_FLAGS",6597069766656),2199023255552 ,'NO DUPLICATE',4398046511104,'DUPLICATE',6597069766656,'DUPLICATE ALL','UNKNOWN'),null)"INMEMORY_DUPLICATE", decode(bitand("A4"."SEGMENT_FLAGS",4294967296),4294967296,decode(bitand("A4"."SEGMENT_FLAGS",841813590016),17179869184, 'NO MEMCOMPRESS',274877906944,'FOR DML',292057776128,'FOR QUERY LOW',549755813888,'FOR QUERY HIGH',566935683072,'FOR CAPACITY LOW' ,824633720832,'FOR CAPACITY HIGH','UNKNOWN'),null)"INMEMORY_COMPRESSION", decode(bitand("A4"."SEGMENT_FLAGS",4362862139015168),281474976710656,'DISABLED',703687441776640,'NO MEMCOMPRESS',1266637395197952 ,'MEMCOMPRESS FOR QUERY',2392537302040576,'MEMCOMPRESS FOR CAPACITY',null)"CELLMEMORY" from ( (select nvl("A112"."NAME",'SYS')"OWNER", "A111"."NAME" "SEGMENT_NAME", "A111"."SUBNAME" "PARTITION_NAME", "A109"."OBJECT_TYPE" "SEGMENT_TYPE", "A109"."OBJECT_TYPE_ID" "OBJECT_TYPE_ID", "A108"."TYPE#" "SEGMENT_TYPE_ID", decode(bitand("A108"."SPARE1",2097408),2097152,'SECUREFILE',256,'ASSM','MSSM')"SEGMENT_SUBTYPE", "A110"."TS#" "TABLESPACE_ID", "A110"."NAME" "TABLESPACE_NAME", "A110"."BLOCKSIZE" "BLOCKSIZE", "A107"."FILE#" "HEADER_FILE", "A108"."BLOCK#" "HEADER_BLOCK", nvl("A108"."BLOCKS",0)* "A110"."BLOCKSIZE" "BYTES", nvl("A108"."BLOCKS",0)"BLOCKS", "A108"."EXTENTS" "EXTENTS", "A108"."INIEXTS" * "A110"."BLOCKSIZE" "INITIAL_EXTENT", "A108"."EXTSIZE" * "A110"."BLOCKSIZE" "NEXT_EXTENT", "A108"."MINEXTS" "MIN_EXTENTS", "A108"."MAXEXTS" "MAX_EXTENTS", decode(bitand("A108"."SPARE1",4194304),4194304,"A108"."BITMAPRANGES",null)"MAX_SIZE", to_char(decode(bitand("A108"."SPARE1",2097152),2097152,decode("A108"."LISTS",0,'NONE',1,'AUTO',2,'MIN',3,'MAX',4,'DEFAULT' ,'INVALID'),null))"RETENTION", decode(bitand("A108"."SPARE1",2097152),2097152,"A108"."GROUPS",null)"MINRETENTION", decode(bitand("A110"."FLAGS",3),1,to_number(null),"A108"."EXTPCT")"PCT_INCREASE", decode(bitand("A110"."FLAGS",32),32,to_number(null),decode("A108"."LISTS",0,1,"A108"."LISTS"))"FREELISTS", decode(bitand("A110"."FLAGS",32),32,to_number(null),decode("A108"."GROUPS",0,1,"A108"."GROUPS"))"FREELIST_GROUPS", "A108"."FILE#" "RELATIVE_FNO", bitand("A108"."CACHEHINT",3)"BUFFER_POOL_ID", bitand("A108"."CACHEHINT",12)/ 4 "FLASH_CACHE", bitand("A108"."CACHEHINT",48)/ 16 "CELL_FLASH_CACHE", nvl("A108"."SPARE1",0)"SEGMENT_FLAGS", decode(bitand("A108"."SPARE1",1),1,"A108"."HWMINCR","A111"."DATAOBJ#")"SEGMENT_OBJD", "A109"."OBJECT_ID" "SEGMENT_OBJN" from "SYS"."USER$" "A112", "SYS"."OBJ$" "A111", "SYS"."TS$" "A110", ( (select decode(bitand("A93"."PROPERTY",8192),8192,'NESTED TABLE','TABLE')"OBJECT_TYPE", 2 "OBJECT_TYPE_ID", 5 "SEGMENT_TYPE_ID", "A93"."OBJ#" "OBJECT_ID", "A93"."FILE#" "HEADER_FILE", "A93"."BLOCK#" "HEADER_BLOCK", "A93"."TS#" "TS_NUMBER" from "SYS"."TAB$" "A93" where bitand("A93"."PROPERTY",1024)= 0 ) union all (select 'TABLE PARTITION' "OBJECT_TYPE", 19 "OBJECT_TYPE_ID", 5 "SEGMENT_TYPE_ID", "A92"."OBJ#" "OBJECT_ID", "A92"."FILE#" "HEADER_FILE", "A92"."BLOCK#" "HEADER_BLOCK", "A92"."TS#" "TS_NUMBER" from "SYS"."TABPART$" "A92" ) union all (select 'CLUSTER' "OBJECT_TYPE", 3 "OBJECT_TYPE_ID", 5 "SEGMENT_TYPE_ID", "A91"."OBJ#" "OBJECT_ID", "A91"."FILE#" "HEADER_FILE", "A91"."BLOCK#" "HEADER_BLOCK", "A91"."TS#" "TS_NUMBER" from "SYS"."CLU$" "A91" ) union all (select decode("A90"."TYPE#",8,'LOBINDEX','INDEX')"OBJECT_TYPE", 1 "OBJECT_TYPE_ID", 6 "SEGMENT_TYPE_ID", "A90"."OBJ#" "OBJECT_ID", "A90"."FILE#" "HEADER_FILE", "A90"."BLOCK#" "HEADER_BLOCK", "A90"."TS#" "TS_NUMBER" from "SYS"."IND$" "A90" where "A90"."TYPE#" = 1 or "A90"."TYPE#" = 2 or "A90"."TYPE#" = 3 or "A90"."TYPE#" = 4 or "A90"."TYPE#" = 6 or "A90"."TYPE#" = 7 or "A90"."TYPE#" = 8 or "A90"."TYPE#" = 9 ) union all (select 'INDEX PARTITION' "OBJECT_TYPE", 20 "OBJECT_TYPE_ID", 6 "SEGMENT_TYPE_ID", "A89"."OBJ#" "OBJECT_ID", "A89"."FILE#" "HEADER_FILE", "A89"."BLOCK#" "HEADER_BLOCK", "A89"."TS#" "TS_NUMBER" from "SYS"."INDPART$" "A89" ) union all (select 'LOBSEGMENT' "OBJECT_TYPE", 21 "OBJECT_TYPE_ID", 8 "SEGMENT_TYPE_ID", "A88"."LOBJ#" "OBJECT_ID", "A88"."FILE#" "HEADER_FILE", "A88"."BLOCK#" "HEADER_BLOCK", "A88"."TS#" "TS_NUMBER" from "SYS"."LOB$" "A88" where bitand("A88"."PROPERTY",64)= 0 or bitand("A88"."PROPERTY",128)= 128 ) union all (select 'TABLE SUBPARTITION' "OBJECT_TYPE", 34 "OBJECT_TYPE_ID", 5 "SEGMENT_TYPE_ID", "A87"."OBJ#" "OBJECT_ID", "A87"."FILE#" "HEADER_FILE", "A87"."BLOCK#" "HEADER_BLOCK", "A87"."TS#" "TS_NUMBER" from "SYS"."TABSUBPART$" "A87" ) union all (select 'INDEX SUBPARTITION' "OBJECT_TYPE", 35 "OBJECT_TYPE_ID", 6 "SEGMENT_TYPE_ID", "A86"."OBJ#" "OBJECT_ID", "A86"."FILE#" "HEADER_FILE", "A86"."BLOCK#" "HEADER_BLOCK", "A86"."TS#" "TS_NUMBER" from "SYS"."INDSUBPART$" "A86" ) union all (select decode("A85"."FRAGTYPE$",'P','LOB PARTITION','LOB SUBPARTITION')"OBJECT_TYPE", decode("A85"."FRAGTYPE$",'P',40,41)"OBJECT_TYPE_ID", 8 "SEGMENT_TYPE_ID", "A85"."FRAGOBJ#" "OBJECT_ID", "A85"."FILE#" "HEADER_FILE", "A85"."BLOCK#" "HEADER_BLOCK", "A85"."TS#" "TS_NUMBER" from "SYS"."LOBFRAG$" "A85" ) )"A109", "SYS"."SEG$" "A108", "SYS"."FILE$" "A107" where "A108"."FILE#" = "A109"."HEADER_FILE" and "A108"."BLOCK#" = "A109"."HEADER_BLOCK" and "A108"."TS#" = "A109"."TS_NUMBER" and "A108"."TS#" = "A110"."TS#" and "A111"."OBJ#" = "A109"."OBJECT_ID" and "A111"."OWNER#" = "A112"."USER#"(+) and "A108"."TYPE#" = "A109"."SEGMENT_TYPE_ID" and "A111"."TYPE#" = "A109"."OBJECT_TYPE_ID" and "A108"."TS#" = "A107"."TS#" and "A108"."FILE#" = "A107"."RELFILE#" and("A111"."TYPE#" <> 1 and "A111"."TYPE#" <> 2 and "A111"."TYPE#" <> 6 or "A111"."TYPE#" = 1 and not exists( select 1 "1" from "SYS"."IND$" "A117", "SYS"."TAB$" "A116", "SYS"."OBJ$" "A115" where "A117"."OBJ#" = "A111"."OBJ#" and "A115"."OBJ#" = "A117"."BO#" and "A115"."TYPE#" = 2 and "A117"."BO#" = "A116"."OBJ#" and bitand("A116"."PROPERTY",power(2,65))= power(2,65) ) or "A111"."TYPE#" = 2 and 1 =( select 1 "1" from "SYS"."TAB$" "A114" where "A114"."OBJ#" = "A111"."OBJ#" and bitand("A114"."PROPERTY",power(2,65))= 0 ) or "A111"."TYPE#" = 6 and 1 =( select 1 "1" from "SYS"."SEQ$" "A113" where "A113"."OBJ#" = "A111"."OBJ#" and bitand("A113"."FLAGS",1024)= 0 )) ) union all (select nvl("A106"."NAME",'SYS')"OWNER", "A104"."NAME" "SEGMENT_NAME", null "PARTITION_NAME", decode("A103"."TYPE#",1,'ROLLBACK',10,'TYPE2 UNDO')"SEGMENT_TYPE", 0 "OBJECT_TYPE_ID", "A103"."TYPE#" "SEGMENT_TYPE_ID", null "SEGMENT_SUBTYPE", "A105"."TS#" "TABLESPACE_ID", "A105"."NAME" "TABLESPACE_NAME", "A105"."BLOCKSIZE" "BLOCKSIZE", "A102"."FILE#" "HEADER_FILE", "A103"."BLOCK#" "HEADER_BLOCK", nvl("A103"."BLOCKS",0)* "A105"."BLOCKSIZE" "BYTES", nvl("A103"."BLOCKS",0)"BLOCKS", "A103"."EXTENTS" "EXTENTS", "A103"."INIEXTS" * "A105"."BLOCKSIZE" "INITIAL_EXTENT", "A103"."EXTSIZE" * "A105"."BLOCKSIZE" "NEXT_EXTENT", "A103"."MINEXTS" "MIN_EXTENTS", "A103"."MAXEXTS" "MAX_EXTENTS", decode(bitand("A103"."SPARE1",4194304),4194304,"A103"."BITMAPRANGES",null)"MAX_SIZE", null "RETENTION", null "MINRETENTION", "A103"."EXTPCT" "PCT_INCREASE", decode(bitand("A105"."FLAGS",32),32,to_number(null),decode("A103"."LISTS",0,1,"A103"."LISTS"))"FREELISTS", decode(bitand("A105"."FLAGS",32),32,to_number(null),decode("A103"."GROUPS",0,1,"A103"."GROUPS"))"FREELIST_GROUPS", "A103"."FILE#" "RELATIVE_FNO", bitand("A103"."CACHEHINT",3)"BUFFER_POOL_ID", bitand("A103"."CACHEHINT",12)/ 4 "FLASH_CACHE", bitand("A103"."CACHEHINT",48)/ 16 "CELL_FLASH_CACHE", nvl("A103"."SPARE1",0)"SEGMENT_FLAGS", "A104"."US#" "SEGMENT_OBJD", 0 "SEGMENT_OBJN" from "SYS"."USER$" "A106", "SYS"."TS$" "A105", "SYS"."UNDO$" "A104", "SYS"."SEG$" "A103", "SYS"."FILE$" "A102" where "A103"."FILE#" = "A104"."FILE#" and "A103"."BLOCK#" = "A104"."BLOCK#" and "A103"."TS#" = "A104"."TS#" and "A103"."TS#" = "A105"."TS#" and "A103"."USER#" = "A106"."USER#"(+) and("A103"."TYPE#" = 1 or "A103"."TYPE#" = 10) and "A104"."STATUS$" <> 1 and "A104"."TS#" = "A102"."TS#" and "A104"."FILE#" = "A102"."RELFILE#" ) union all (select nvl("A101"."NAME",'SYS')"OWNER", to_char("A98"."FILE#") || '.' || to_char("A99"."BLOCK#")"SEGMENT_NAME", null "PARTITION_NAME", decode("A99"."TYPE#",2,'DEFERRED ROLLBACK',3,'TEMPORARY',4,'CACHE',9,'SPACE HEADER','UNDEFINED')"SEGMENT_TYPE", 0 "OBJECT_TYPE_ID", "A99"."TYPE#" "SEGMENT_TYPE_ID", null "SEGMENT_SUBTYPE", "A100"."TS#" "TABLESPACE_ID", "A100"."NAME" "TABLESPACE_NAME", "A100"."BLOCKSIZE" "BLOCKSIZE", "A98"."FILE#" "HEADER_FILE", "A99"."BLOCK#" "HEADER_BLOCK", nvl("A99"."BLOCKS",0)* "A100"."BLOCKSIZE" "BYTES", nvl("A99"."BLOCKS",0)"BLOCKS", "A99"."EXTENTS" "EXTENTS", "A99"."INIEXTS" * "A100"."BLOCKSIZE" "INITIAL_EXTENT", "A99"."EXTSIZE" * "A100"."BLOCKSIZE" "NEXT_EXTENT", "A99"."MINEXTS" "MIN_EXTENTS", "A99"."MAXEXTS" "MAX_EXTENTS", decode(bitand("A99"."SPARE1",4194304),4194304,"A99"."BITMAPRANGES",null)"MAX_SIZE", null "RETENTION", null "MINRETENTION", decode(bitand("A100"."FLAGS",3),1,to_number(null),"A99"."EXTPCT")"PCT_INCREASE", decode(bitand("A100"."FLAGS",32),32,to_number(null),decode("A99"."LISTS",0,1,"A99"."LISTS"))"FREELISTS", decode(bitand("A100"."FLAGS",32),32,to_number(null),decode("A99"."GROUPS",0,1,"A99"."GROUPS"))"FREELIST_GROUPS", "A99"."FILE#" "RELATIVE_FNO", bitand("A99"."CACHEHINT",3)"BUFFER_POOL_ID", bitand("A99"."CACHEHINT",12)/ 4 "FLASH_CACHE", bitand("A99"."CACHEHINT",48)/ 16 "CELL_FLASH_CACHE", nvl("A99"."SPARE1",0)"SEGMENT_FLAGS", "A99"."HWMINCR" "SEGMENT_OBJD", 0 "SEGMENT_OBJN" from "SYS"."USER$" "A101", "SYS"."TS$" "A100", "SYS"."SEG$" "A99", "SYS"."FILE$" "A98" where "A99"."TS#" = "A100"."TS#" and "A99"."USER#" = "A101"."USER#"(+) and "A99"."TYPE#" <> 1 and "A99"."TYPE#" <> 5 and "A99"."TYPE#" <> 6 and "A99"."TYPE#" <> 8 and "A99"."TYPE#" <> 10 and "A99"."TYPE#" <> 11 and "A99"."TS#" = "A98"."TS#" and "A99"."FILE#" = "A98"."RELFILE#" ) union all (select nvl("A97"."NAME",'SYS')"OWNER", 'HEATMAP' "SEGMENT_NAME", null "PARTITION_NAME", 'SYSTEM STATISTICS' "SEGMENT_TYPE", 0 "OBJECT_TYPE_ID", "A95"."TYPE#" "SEGMENT_TYPE_ID", null "SEGMENT_SUBTYPE", "A96"."TS#" "TABLESPACE_ID", "A96"."NAME" "TABLESPACE_NAME", "A96"."BLOCKSIZE" "BLOCKSIZE", "A94"."FILE#" "HEADER_FILE", "A95"."BLOCK#" "HEADER_BLOCK", nvl("A95"."BLOCKS",0)* "A96"."BLOCKSIZE" "BYTES", nvl("A95"."BLOCKS",0)"BLOCKS", "A95"."EXTENTS" "EXTENTS", "A95"."INIEXTS" * "A96"."BLOCKSIZE" "INITIAL_EXTENT", "A95"."EXTSIZE" * "A96"."BLOCKSIZE" "NEXT_EXTENT", "A95"."MINEXTS" "MIN_EXTENTS", "A95"."MAXEXTS" "MAX_EXTENTS", decode(bitand("A95"."SPARE1",4194304),4194304,"A95"."BITMAPRANGES",null)"MAX_SIZE", null "RETENTION", null "MINRETENTION", decode(bitand("A96"."FLAGS",3),1,to_number(null),"A95"."EXTPCT")"PCT_INCREASE", decode(bitand("A96"."FLAGS",32),32,to_number(null),decode("A95"."LISTS",0,1,"A95"."LISTS"))"FREELISTS", decode(bitand("A96"."FLAGS",32),32,to_number(null),decode("A95"."GROUPS",0,1,"A95"."GROUPS"))"FREELIST_GROUPS", "A95"."FILE#" "RELATIVE_FNO", bitand("A95"."CACHEHINT",3)"BUFFER_POOL_ID", bitand("A95"."CACHEHINT",12)/ 4 "FLASH_CACHE", bitand("A95"."CACHEHINT",48)/ 16 "CELL_FLASH_CACHE", nvl("A95"."SPARE1",0)"SEGMENT_FLAGS", "A95"."HWMINCR" "SEGMENT_OBJD", 0 "SEGMENT_OBJN" from "SYS"."USER$" "A97", "SYS"."TS$" "A96", "SYS"."SEG$" "A95", "SYS"."FILE$" "A94" where "A95"."TS#" = "A96"."TS#" and "A95"."USER#" = "A97"."USER#"(+) and "A95"."TYPE#" = 11 and "A95"."TS#" = "A94"."TS#" and "A95"."FILE#" = "A94"."RELFILE#" ) )"A4" )"A3", ( select "A7"."NAME" "OWNER", "A8"."NAME" "OBJECT_NAME", "A8"."SUBNAME" "SUBOBJECT_NAME", "A8"."OBJ#" "OBJECT_ID", "A8"."DATAOBJ#" "DATA_OBJECT_ID", decode("A8"."TYPE#",0,'NEXT OBJECT',1,'INDEX',2,'TABLE',3,'CLUSTER',4,'VIEW',5,'SYNONYM',6,'SEQUENCE',7,'PROCEDURE',8,'FUNCTION' ,9,'PACKAGE',11,'PACKAGE BODY',12,'TRIGGER',13,'TYPE',14,'TYPE BODY',19,'TABLE PARTITION',20,'INDEX PARTITION',21,'LOB' ,22,'LIBRARY',23,'DIRECTORY',24,'QUEUE',28,'JAVA SOURCE',29,'JAVA CLASS',30,'JAVA RESOURCE',32,'INDEXTYPE',33,'OPERATOR' ,34,'TABLE SUBPARTITION',35,'INDEX SUBPARTITION',40,'LOB PARTITION',41,'LOB SUBPARTITION',42, case( select bitand("A68"."XPFLAGS",8388608 + 34359738368)"BITAND(S.XPFLAGS,8388608+34359738368)" from "SYS"."SUM$" "A68" where "A68"."OBJ#" = "A8"."OBJ#" ) when 8388608 then 'REWRITE EQUIVALENCE' when 34359738368 then 'MATERIALIZED ZONEMAP' else 'MATERIALIZED VIEW' end,43,'DIMENSION',44,'CONTEXT',46,'RULE SET',47,'RESOURCE PLAN',48,'CONSUMER GROUP',55,'XML SCHEMA',56,'JAVA DATA' ,57,'EDITION',59,'RULE',60,'CAPTURE',61,'APPLY',62,'EVALUATION CONTEXT',66,'JOB',67,'PROGRAM',68,'JOB CLASS',69, 'WINDOW',72,'SCHEDULER GROUP',74,'SCHEDULE',79,'CHAIN',81,'FILE GROUP',82,'MINING MODEL',87,'ASSEMBLY',90,'CREDENTIAL' ,92,'CUBE DIMENSION',93,'CUBE',94,'MEASURE FOLDER',95,'CUBE BUILD PROCESS',100,'FILE WATCHER',101,'DESTINATION', 114,'SQL TRANSLATION PROFILE',115,'UNIFIED AUDIT POLICY',144,'MINING MODEL PARTITION',148,'LOCKDOWN PROFILE',150 ,'HIERARCHY',151,'ATTRIBUTE DIMENSION',152,'ANALYTIC VIEW','UNDEFINED')"OBJECT_TYPE", "A8"."CTIME" "CREATED", "A8"."MTIME" "LAST_DDL_TIME", to_char("A8"."STIME",'YYYY-MM-DD:HH24:MI:SS')"TIMESTAMP", decode("A8"."STATUS",0,'N/A',1,'VALID','INVALID')"STATUS", decode(bitand("A8"."FLAGS",2),0,'N',2,'Y','N')"TEMPORARY", decode(bitand("A8"."FLAGS",4),0,'N',4,'Y','N')"GENERATED", decode(bitand("A8"."FLAGS",16),0,'N',16,'Y','N')"SECONDARY", "A8"."NAMESPACE" "NAMESPACE", "A8"."DEFINING_EDITION" "EDITION_NAME", decode(bitand("A8"."FLAGS",65536 + 131072 + 4294967296),4294967296 + 65536,'EXTENDED DATA LINK',65536,'METADATA LINK',131072 ,'DATA LINK','NONE')"SHARING", case when("A8"."TYPE#" = 4 or "A8"."TYPE#" = 5 or "A8"."TYPE#" = 7 or "A8"."TYPE#" = 8 or "A8"."TYPE#" = 9 or "A8"."TYPE#" = 11 or "A8"."TYPE#" = 12 or "A8"."TYPE#" = 13 or "A8"."TYPE#" = 14 or "A8"."TYPE#" = 22 or "A8"."TYPE#" = 87 or "A8"."TYPE#" = 114)then decode(bitand("A8"."FLAGS",1048576),0,'Y',1048576,'N','Y') else null end "EDITIONABLE", decode(bitand("A8"."FLAGS",4194304),4194304,'Y','N')"ORACLE_MAINTAINED", decode(bitand("A8"."FLAGS",134217728),134217728,'Y','N')"APPLICATION", case when("A8"."TYPE#" = 2 or "A8"."TYPE#" = 4 or "A8"."TYPE#" = 7 or "A8"."TYPE#" = 8 or "A8"."TYPE#" = 9 or "A8"."TYPE#" = 12 or "A8"."TYPE#" = 13)then nls_collation_name(nvl("A8"."DFLCOLLID",16382)) when("A8"."TYPE#" = 42 and exists( select 1 "1" from "SYS"."SUM$" "A67" where "A67"."OBJ#" = "A8"."OBJ#" and bitand("A67"."XPFLAGS",8388608 + 34359738368)= 0 ))then nls_collation_name(nvl("A8"."DFLCOLLID",16382)) else null end "DEFAULT_COLLATION", decode(bitand("A8"."FLAGS",2684354560),0,'N',2147483648,'Y',536870912,'Y',2684354560,'Y','N')"DUPLICATED", decode(bitand("A8"."FLAGS",1073741824),0,'N',1073741824,'Y','N')"SHARDED", "A8"."CREAPPID" "CREATED_APPID", "A8"."CREVERID" "CREATED_VSNID", "A8"."MODAPPID" "MODIFIED_APPID", "A8"."MODVERID" "MODIFIED_VSNID" from ( select "A32"."OBJ#" "OBJ#", "A32"."DATAOBJ#" "DATAOBJ#", "A32"."OWNER#" "DEFINING_OWNER#", "A32"."NAME" "NAME", "A32"."NAMESPACE" "NAMESPACE", "A32"."SUBNAME" "SUBNAME", "A32"."TYPE#" "TYPE#", "A32"."CTIME" "CTIME", "A32"."MTIME" "MTIME", "A32"."STIME" "STIME", "A32"."STATUS" "STATUS", "A32"."REMOTEOWNER" "REMOTEOWNER", "A32"."LINKNAME" "LINKNAME", "A32"."FLAGS" "FLAGS", "A32"."OID$" "OID$", "A32"."SPARE1" "SPARE1", "A32"."SPARE2" "SPARE2", "A32"."SPARE3" "SPARE3", "A32"."SPARE4" "SPARE4", "A32"."SPARE5" "SPARE5", "A32"."SPARE6" "SPARE6", "A32"."SIGNATURE" "SIGNATURE", "A32"."SPARE7" "SPARE7", "A32"."SPARE8" "SPARE8", "A32"."SPARE9" "SPARE9", "A32"."DFLCOLLID" "DFLCOLLID", "A32"."CREAPPID" "CREAPPID", "A32"."CREVERID" "CREVERID", "A32"."CREPATCHID" "CREPATCHID", "A32"."MODAPPID" "MODAPPID", "A32"."MODVERID" "MODVERID", "A32"."MODPATCHID" "MODPATCHID", "A32"."SPARE10" "SPARE10", "A32"."SPARE11" "SPARE11", "A32"."SPARE12" "SPARE12", "A32"."SPARE13" "SPARE13", "A32"."SPARE14" "SPARE14", "A32"."SPARE3" "OWNER#", case when("A32"."TYPE#" <> all( select "A38"."TYPE#" "TYPE#" from "SYS"."USER_EDITIONING$" "A38" where "A38"."USER#" = "A32"."SPARE3" ) or bitand("A32"."FLAGS",1048576)= 1048576 or bitand("A31"."SPARE1",16)= 0)then null when "A31"."TYPE#" = 2 then ( select "A37"."NAME" "NAME" from "SYS"."OBJ$" "A37" where "A37"."OBJ#" = "A31"."SPARE2" ) else 'ORA$BASE' end "DEFINING_EDITION" from "SYS"."OBJ$" "A32", "SYS"."USER$" "A31" where "A32"."OWNER#" = "A31"."USER#" and("A32"."TYPE#" <> all( select "A36"."TYPE#" "TYPE#" from "SYS"."USER_EDITIONING$" "A36" where "A36"."USER#" = "A32"."SPARE3" ) and "A32"."TYPE#" <> 88 or bitand("A32"."FLAGS",1048576)= 1048576 or bitand("A31"."SPARE1",16)= 0 or "A32"."TYPE#" = any( select "A35"."TYPE#" "TYPE#" from "SYS"."USER_EDITIONING$" "A35" where "A35"."USER#" = "A32"."SPARE3" ) and("A31"."TYPE#" <> 2 and sys_context('userenv','current_edition_name')= 'ORA$BASE' or "A31"."TYPE#" = 2 and "A31"."SPARE2" = sys_context('userenv','current_edition_id') or exists( select 1 "1" from "SYS"."OBJ$" "A34", "SYS"."USER$" "A33" where "A34"."TYPE#" = 88 and "A34"."DATAOBJ#" = "A32"."OBJ#" and "A34"."OWNER#" = "A33"."USER#" and "A33"."TYPE#" = 2 and "A33"."SPARE2" = sys_context('userenv','current_edition_id') ))) )"A8", "SYS"."USER$" "A7" where "A8"."OWNER#" = "A7"."USER#" and "A8"."LINKNAME" is null and("A8"."TYPE#" <> 1 and "A8"."TYPE#" <> 10 or "A8"."TYPE#" = 1 and 1 =( select 1 "1" from "SYS"."IND$" "A66" where "A66"."OBJ#" = "A8"."OBJ#" and("A66"."TYPE#" = 1 or "A66"."TYPE#" = 2 or "A66"."TYPE#" = 3 or "A66"."TYPE#" = 4 or "A66"."TYPE#" = 6 or "A66"."TYPE#" = 7 or "A66"."TYPE#" = 9) )) and "A8"."NAME" <> '_NEXT_OBJECT' and "A8"."NAME" <> '_default_auditing_options_' and bitand("A8"."FLAGS",128)= 0 and("A8"."TYPE#" <> 1 and "A8"."TYPE#" <> 2 and "A8"."TYPE#" <> 6 or "A8"."TYPE#" = 1 and not exists( select 1 "1" from "SYS"."IND$" "A65", "SYS"."TAB$" "A64", "SYS"."OBJ$" "A63" where "A65"."OBJ#" = "A8"."OBJ#" and "A63"."OBJ#" = "A65"."BO#" and "A63"."TYPE#" = 2 and "A65"."BO#" = "A64"."OBJ#" and bitand("A64"."PROPERTY",power(2,65))= power(2,65) ) or "A8"."TYPE#" = 2 and 1 =( select 1 "1" from "SYS"."TAB$" "A62" where "A62"."OBJ#" = "A8"."OBJ#" and(bitand("A62"."PROPERTY",power(2,65))= 0 or "A62"."PROPERTY" is null) ) or "A8"."TYPE#" = 6 and 1 =( select 1 "1" from "SYS"."SEQ$" "A61" where "A61"."OBJ#" = "A8"."OBJ#" and(bitand("A61"."FLAGS",1024)= 0 or "A61"."FLAGS" is null) )) and("A8"."OWNER#" = userenv('SCHEMAID') or "A8"."OWNER#" = 1 or "A8"."TYPE#" <> 7 and "A8"."TYPE#" <> 8 and "A8"."TYPE#" <> 9 and "A8"."TYPE#" <> 11 and "A8"."TYPE#" <> 12 and "A8"."TYPE#" <> 13 and "A8"."TYPE#" <> 14 and "A8"."TYPE#" <> 28 and "A8"."TYPE#" <> 29 and "A8"."TYPE#" <> 30 and "A8"."TYPE#" <> 56 and "A8"."TYPE#" <> 93 and "A8"."OBJ#" = any( select "A60"."OBJ#" "OBJ#" from "SYS"."OBJAUTH$" "A60" where "A60"."GRANTEE#" = any( select "A69"."KZSROROL" "KZSROROL" from ( select "A30"."ADDR" "ADDR", "A30"."INDX" "INDX", "A30"."INST_ID" "INST_ID", "A30"."CON_ID" "CON_ID", "A30"."KZSROROL" "KZSROROL", "A30"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A30" where "A30"."CON_ID" = 0 or "A30"."CON_ID" = 3 )"A69" ) and("A60"."PRIVILEGE#" = 3 or "A60"."PRIVILEGE#" = 6 or "A60"."PRIVILEGE#" = 7 or "A60"."PRIVILEGE#" = 9 or "A60"."PRIVILEGE#" = 10 or "A60"."PRIVILEGE#" = 12 or "A60"."PRIVILEGE#" = 11 or "A60"."PRIVILEGE#" = 16 or "A60"."PRIVILEGE#" = 17 or "A60"."PRIVILEGE#" = 18) ) or("A8"."TYPE#" = 7 or "A8"."TYPE#" = 8 or "A8"."TYPE#" = 9 or "A8"."TYPE#" = 28 or "A8"."TYPE#" = 29 or "A8"."TYPE#" = 30 or "A8"."TYPE#" = 56) and(exists( select null "NULL" from "SYS"."OBJAUTH$" "A59" where "A59"."OBJ#" = "A8"."OBJ#" and "A59"."GRANTEE#" = any( select "A70"."KZSROROL" "KZSROROL" from ( select "A29"."ADDR" "ADDR", "A29"."INDX" "INDX", "A29"."INST_ID" "INST_ID", "A29"."CON_ID" "CON_ID", "A29"."KZSROROL" "KZSROROL", "A29"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A29" where "A29"."CON_ID" = 0 or "A29"."CON_ID" = 3 )"A70" ) and("A59"."PRIVILEGE#" = 12 or "A59"."PRIVILEGE#" = 26) ) or ora_check_sys_privilege("A8"."OWNER#","A8"."TYPE#")= 1) or "A8"."TYPE#" = 19 and(exists( select "A58"."BO#" "BO#" from "SYS"."TABPART$" "A58" where "A58"."OBJ#" = "A8"."OBJ#" and "A58"."BO#" = any( select "A71"."OBJ#" "OBJ#" from "SYS"."OBJAUTH$" "A71" where "A71"."GRANTEE#" = any( select "A72"."KZSROROL" "KZSROROL" from ( select "A28"."ADDR" "ADDR", "A28"."INDX" "INDX", "A28"."INST_ID" "INST_ID", "A28"."CON_ID" "CON_ID", "A28"."KZSROROL" "KZSROROL", "A28"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A28" where "A28"."CON_ID" = 0 or "A28"."CON_ID" = 3 )"A72" ) and("A71"."PRIVILEGE#" = 9 or "A71"."PRIVILEGE#" = 17) ) ) or exists( select "A57"."BO#" "BO#" from "SYS"."TABCOMPART$" "A57" where "A57"."OBJ#" = "A8"."OBJ#" and "A57"."BO#" = any( select "A73"."OBJ#" "OBJ#" from "SYS"."OBJAUTH$" "A73" where "A73"."GRANTEE#" = any( select "A74"."KZSROROL" "KZSROROL" from ( select "A27"."ADDR" "ADDR", "A27"."INDX" "INDX", "A27"."INST_ID" "INST_ID", "A27"."CON_ID" "CON_ID", "A27"."KZSROROL" "KZSROROL", "A27"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A27" where "A27"."CON_ID" = 0 or "A27"."CON_ID" = 3 )"A74" ) and("A73"."PRIVILEGE#" = 9 or "A73"."PRIVILEGE#" = 17) ) )) or "A8"."TYPE#" = 34 and exists( select "A55"."BO#" "BO#" from "SYS"."TABSUBPART$" "A56", "SYS"."TABCOMPART$" "A55" where "A56"."OBJ#" = "A8"."OBJ#" and "A56"."POBJ#" = "A55"."OBJ#" and "A55"."BO#" = any( select "A75"."OBJ#" "OBJ#" from "SYS"."OBJAUTH$" "A75" where "A75"."GRANTEE#" = any( select "A76"."KZSROROL" "KZSROROL" from ( select "A26"."ADDR" "ADDR", "A26"."INDX" "INDX", "A26"."INST_ID" "INST_ID", "A26"."CON_ID" "CON_ID", "A26"."KZSROROL" "KZSROROL", "A26"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A26" where "A26"."CON_ID" = 0 or "A26"."CON_ID" = 3 )"A76" ) and("A75"."PRIVILEGE#" = 9 or "A75"."PRIVILEGE#" = 17) ) ) or "A8"."TYPE#" = 12 and(exists( select null "NULL" from "SYS"."TRIGGER$" "A54", "SYS"."OBJAUTH$" "A53" where bitand("A54"."PROPERTY",24)= 0 and "A54"."OBJ#" = "A8"."OBJ#" and "A53"."OBJ#" = "A54"."BASEOBJECT" and "A53"."GRANTEE#" = any( select "A77"."KZSROROL" "KZSROROL" from ( select "A25"."ADDR" "ADDR", "A25"."INDX" "INDX", "A25"."INST_ID" "INST_ID", "A25"."CON_ID" "CON_ID", "A25"."KZSROROL" "KZSROROL", "A25"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A25" where "A25"."CON_ID" = 0 or "A25"."CON_ID" = 3 )"A77" ) and "A53"."PRIVILEGE#" = 26 ) or ora_check_sys_privilege("A8"."OWNER#","A8"."TYPE#")= 1) or "A8"."TYPE#" = 11 and(exists( select null "NULL" from ( select "A24"."OBJ#" "OBJ#", "A24"."NAME" "NAME", "A24"."TYPE#" "TYPE#", "A24"."SPARE3" "OWNER#" from "SYS"."OBJ$" "A24", "SYS"."USER$" "A23" where "A24"."OWNER#" = "A23"."USER#" and "A24"."TYPE#" <> 88 )"A52", "SYS"."DEPENDENCY$" "A51", "SYS"."OBJAUTH$" "A50" where "A52"."OWNER#" = "A8"."OWNER#" and "A52"."NAME" = "A8"."NAME" and "A52"."TYPE#" = 9 and "A51"."D_OBJ#" = "A8"."OBJ#" and "A51"."P_OBJ#" = "A52"."OBJ#" and "A50"."OBJ#" = "A52"."OBJ#" and "A50"."GRANTEE#" = any( select "A78"."KZSROROL" "KZSROROL" from ( select "A22"."ADDR" "ADDR", "A22"."INDX" "INDX", "A22"."INST_ID" "INST_ID", "A22"."CON_ID" "CON_ID", "A22"."KZSROROL" "KZSROROL", "A22"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A22" where "A22"."CON_ID" = 0 or "A22"."CON_ID" = 3 )"A78" ) and "A50"."PRIVILEGE#" = 26 ) or ora_check_sys_privilege("A8"."OWNER#","A8"."TYPE#")= 1) or "A8"."TYPE#" = 1 and exists( select "A49"."OBJ#" "OBJ#" from "SYS"."IND$" "A49" where "A49"."OBJ#" = "A8"."OBJ#" and exists( select null "NULL" from "SYS"."OBJAUTH$" "A79" where "A79"."OBJ#" = "A49"."BO#" and "A79"."GRANTEE#" = any( select "A80"."KZSROROL" "KZSROROL" from ( select "A21"."ADDR" "ADDR", "A21"."INDX" "INDX", "A21"."INST_ID" "INST_ID", "A21"."CON_ID" "CON_ID", "A21"."KZSROROL" "KZSROROL", "A21"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A21" where "A21"."CON_ID" = 0 or "A21"."CON_ID" = 3 )"A80" ) ) ) or "A8"."TYPE#" = 13 and(exists( select null "NULL" from "SYS"."OBJAUTH$" "A48" where "A48"."OBJ#" = "A8"."OBJ#" and "A48"."GRANTEE#" = any( select "A81"."KZSROROL" "KZSROROL" from ( select "A20"."ADDR" "ADDR", "A20"."INDX" "INDX", "A20"."INST_ID" "INST_ID", "A20"."CON_ID" "CON_ID", "A20"."KZSROROL" "KZSROROL", "A20"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A20" where "A20"."CON_ID" = 0 or "A20"."CON_ID" = 3 )"A81" ) and("A48"."PRIVILEGE#" = 12 or "A48"."PRIVILEGE#" = 26) ) or ora_check_sys_privilege("A8"."OWNER#","A8"."TYPE#")= 1) or "A8"."TYPE#" = 14 and(exists( select null "NULL" from ( select "A19"."OBJ#" "OBJ#", "A19"."NAME" "NAME", "A19"."TYPE#" "TYPE#", "A19"."SPARE3" "OWNER#" from "SYS"."OBJ$" "A19", "SYS"."USER$" "A18" where "A19"."OWNER#" = "A18"."USER#" and "A19"."TYPE#" <> 88 )"A47", "SYS"."DEPENDENCY$" "A46", "SYS"."OBJAUTH$" "A45" where "A47"."OWNER#" = "A8"."OWNER#" and "A47"."NAME" = "A8"."NAME" and "A47"."TYPE#" = 13 and "A46"."D_OBJ#" = "A8"."OBJ#" and "A46"."P_OBJ#" = "A47"."OBJ#" and "A45"."OBJ#" = "A47"."OBJ#" and "A45"."GRANTEE#" = any( select "A82"."KZSROROL" "KZSROROL" from ( select "A17"."ADDR" "ADDR", "A17"."INDX" "INDX", "A17"."INST_ID" "INST_ID", "A17"."CON_ID" "CON_ID", "A17"."KZSROROL" "KZSROROL", "A17"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A17" where "A17"."CON_ID" = 0 or "A17"."CON_ID" = 3 )"A82" ) and "A45"."PRIVILEGE#" = 26 ) or ora_check_sys_privilege("A8"."OWNER#","A8"."TYPE#")= 1) or("A8"."TYPE#" = 1 or "A8"."TYPE#" = 2 or "A8"."TYPE#" = 3 or "A8"."TYPE#" = 4 or "A8"."TYPE#" = 5 or "A8"."TYPE#" = 6 or "A8"."TYPE#" = 19 or "A8"."TYPE#" = 20 or "A8"."TYPE#" = 22 or "A8"."TYPE#" = 23 or "A8"."TYPE#" = 32 or "A8"."TYPE#" = 33 or "A8"."TYPE#" = 34 or "A8"."TYPE#" = 35 or "A8"."TYPE#" = 42 or "A8"."TYPE#" = 44 or "A8"."TYPE#" = 46 or "A8"."TYPE#" = 48 or "A8"."TYPE#" = 59 or "A8"."TYPE#" = 62 or "A8"."TYPE#" = 66 or "A8"."TYPE#" = 67 or "A8"."TYPE#" = 68 or "A8"."TYPE#" = 79 or "A8"."TYPE#" = 81 or "A8"."TYPE#" = 82 or "A8"."TYPE#" = 87 or "A8"."TYPE#" = 92 or "A8"."TYPE#" = 94 or "A8"."TYPE#" = 95 or "A8"."TYPE#" = 100) and ora_check_sys_privilege("A8"."OWNER#","A8"."TYPE#")= 1 or "A8"."TYPE#" = 55 and 1 =( select /*+ NO_MERGE */ "SYS"."XML_SCHEMA_NAME_PRESENT"."IS_SCHEMA_PRESENT"("A8"."NAME","A44"."ID2")"ID1" from ( select /*+ NO_MERGE */ userenv('SCHEMAID')"ID2" from "SYS"."DUAL" "A16" )"A44" ) or "A8"."TYPE#" = 69 or "A8"."TYPE#" = 72 or "A8"."TYPE#" = 74 or "A8"."TYPE#" = 101 or "A8"."TYPE#" = 57 or "A8"."TYPE#" = 93 and("A8"."OBJ#" = any( select "A43"."OBJ#" "OBJ#" from "SYS"."OBJAUTH$" "A43" where "A43"."GRANTEE#" = any( select "A83"."KZSROROL" "KZSROROL" from ( select "A15"."ADDR" "ADDR", "A15"."INDX" "INDX", "A15"."INST_ID" "INST_ID", "A15"."CON_ID" "CON_ID", "A15"."KZSROROL" "KZSROROL", "A15"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A15" where "A15"."CON_ID" = 0 or "A15"."CON_ID" = 3 )"A83" ) ) or ora_check_sys_privilege("A8"."OWNER#","A8"."TYPE#")= 1) and 1 =( select decode("A42"."HAVE_ALL_DIM_ACCESS",null,1,"A42"."HAVE_ALL_DIM_ACCESS")"DECODE(HAVE_ALL_DIM_ACCESS,NULL,1,HAVE_ALL_DIM_ACCESS)" from ( select "A10"."OBJ#" "OBJ#", min("A10"."HAVE_DIM_ACCESS")"HAVE_ALL_DIM_ACCESS" from ( select "A13"."OBJ#" "OBJ#", case when("A11"."OWNER#" = userenv('SCHEMAID') or "A11"."OWNER#" = 1 or "A11"."OBJ#" = any( select "A39"."OBJ#" "OBJ#" from "SYS"."OBJAUTH$" "A39" where "A39"."GRANTEE#" = any( select "A40"."KZSROROL" "KZSROROL" from ( select "A14"."ADDR" "ADDR", "A14"."INDX" "INDX", "A14"."INST_ID" "INST_ID", "A14"."CON_ID" "CON_ID", "A14"."KZSROROL" "KZSROROL", "A14"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A14" where "A14"."CON_ID" = 0 or "A14"."CON_ID" = 3 )"A40" ) ) or ora_check_sys_privilege("A11"."OWNER#","A11"."TYPE#")= 1)then 1 else 0 end "HAVE_DIM_ACCESS" from "SYS"."OLAP_CUBES$" "A13", "SYS"."DEPENDENCY$" "A12", "SYS"."OBJ$" "A11" where "A11"."OBJ#" = "A12"."P_OBJ#" and "A11"."TYPE#" = 92 and "A13"."OBJ#" = "A12"."D_OBJ#" )"A10" group by "A10"."OBJ#" )"A42" where "A8"."OBJ#" = "A42"."OBJ#"(+) ) or "A8"."TYPE#" = 114 and(exists( select null "NULL" from "SYS"."OBJAUTH$" "A41" where "A41"."OBJ#" = "A8"."OBJ#" and "A41"."GRANTEE#" = any( select "A84"."KZSROROL" "KZSROROL" from ( select "A9"."ADDR" "ADDR", "A9"."INDX" "INDX", "A9"."INST_ID" "INST_ID", "A9"."CON_ID" "CON_ID", "A9"."KZSROROL" "KZSROROL", "A9"."KZSROFLG" "KZSROFLG" from "SYS"."X$KZSRO" "A9" where "A9"."CON_ID" = 0 or "A9"."CON_ID" = 3 )"A84" ) and("A41"."PRIVILEGE#" = 0 or "A41"."PRIVILEGE#" = 29) ) or ora_check_sys_privilege("A8"."OWNER#","A8"."TYPE#")= 1) or("A8"."TYPE#" = 150 or "A8"."TYPE#" = 151 or "A8"."TYPE#" = 152) and ora_check_sys_privilege("A8"."OWNER#","A8"."TYPE#")= 1) )"A2" where "A2"."OWNER" = "A3"."OWNER" and "A2"."OBJECT_NAME" = "A3"."SEGMENT_NAME" )"A1"
DISCLAIMER: We've captured these popular historical magazine articles for your reference. Links etc contained within these article possibly won't work. These articles are provided as-is with no guarantee that the information within them is the best advice for current versions of the Oracle Database.