DBA Data[Home] [Help]

APPS.WF_INSTALL dependencies on USER_INDEXES

Line 506: FROM USER_INDEXES I, USER_TABLES T

502: SELECT I.TABLESPACE_NAME, I.INITIAL_EXTENT, I.NEXT_EXTENT, I.PCT_INCREASE,
503: I.PARTITIONED, T.PARTITIONED
504: INTO v_tablespace_name, v_initial, v_next, v_pctinc,
505: v_idxpartitioned, v_tblpartitioned
506: FROM USER_INDEXES I, USER_TABLES T
507: WHERE I.INDEX_NAME = idxname
508: AND I.TABLE_NAME = T.TABLE_NAME;
509:
510: -- initial extent could be much larger than next extent

Line 529: FROM USER_INDEXES I, USER_TABLES T, USER_PART_INDEXES UPI

525: NVL(to_char(I.PCT_INCREASE),UPI.DEF_PCT_INCREASE),
526: I.PARTITIONED, T.PARTITIONED
527: INTO v_tablespace_name, v_initial, v_next, v_pctinc,
528: v_idxpartitioned, v_tblpartitioned
529: FROM USER_INDEXES I, USER_TABLES T, USER_PART_INDEXES UPI
530: WHERE I.INDEX_NAME = idxname
531: AND I.TABLE_NAME = T.TABLE_NAME
532: AND UPI.INDEX_NAME(+) = I.INDEX_NAME;
533:

Line 1362: SELECT INDEX_NAME FROM USER_INDEXES WHERE PARTITIONED='||'''NO'''

1358: where tablespace_name = p_tablespace;
1359:
1360: statement := 'SELECT SUM(BYTES)/1024/1024 FROM USER_SEGMENTS
1361: WHERE TABLESPACE_NAME = '''||p_tablespace||''' AND SEGMENT_NAME in (
1362: SELECT INDEX_NAME FROM USER_INDEXES WHERE PARTITIONED='||'''NO'''
1363: ||' AND TABLE_NAME IN ('||table_list||')
1364: UNION
1365: SELECT TABLE_NAME from USER_TABLES WHERE PARTITIONED='||'''NO'''
1366: ||' AND TABLE_NAME IN ('||table_list||'))';