SYS.DBMS_FEATURE_SEG_MAIN_ONL_COMP dependencies on TABPART$

Line 10: -- select from tabpart$

6: partnFragsCompressed NUMBER;
7: subpartnFragsCompressed NUMBER;
8: fragObjNumListStr VARCHAR2(1000);
9:
10: -- select from tabpart$
11: cursor tp_cursor is select tp.obj# from sys.tabpart$ tp
12: where bitand(tp.flags, 33554432) = 33554432;
13:
14: -- select from tabsubpart$

Line 11: cursor tp_cursor is select tp.obj# from sys.tabpart$ tp

7: subpartnFragsCompressed NUMBER;
8: fragObjNumListStr VARCHAR2(1000);
9:
10: -- select from tabpart$
11: cursor tp_cursor is select tp.obj# from sys.tabpart$ tp
12: where bitand(tp.flags, 33554432) = 33554432;
13:
14: -- select from tabsubpart$
15: cursor tsp_cursor is select tsp.obj# from sys.tabsubpart$ tsp

Line 25: from sys.tabpart$ where bitand(flags, 33554432) = 33554432;

21: fragObjNumListStr := NULL;
22:
23: -- count partitions compressed through an online PMOP
24: select count(*) into partnFragsCompressed
25: from sys.tabpart$ where bitand(flags, 33554432) = 33554432;
26:
27: -- count subpartitions compressed through an online PMOP
28: select count(*) into subpartnFragsCompressed
29: from sys.tabsubpart$ where bitand(flags, 33554432) = 33554432;

Line 31: -- loop through tabpart$

27: -- count subpartitions compressed through an online PMOP
28: select count(*) into subpartnFragsCompressed
29: from sys.tabsubpart$ where bitand(flags, 33554432) = 33554432;
30:
31: -- loop through tabpart$
32: if (partnFragsCompressed > 0) then
33: isAnyFragCompressed := 1;
34: fragObjNumListStr := fragObjNumListStr || 'Partition Obj# list: ';
35: for ri in tp_cursor