[Home] [Help]
25: g_Errors Error_Out;
26: -- New cursort to support MVs
27: CURSOR schema_cur IS
28: SELECT upper(oracle_username) sname
29: FROM fnd_oracle_userid
30: WHERE oracle_id BETWEEN 900 AND 999
31: AND read_only_flag = 'U'
32:
33: UNION ALL
32:
33: UNION ALL
34:
35: SELECT DISTINCT upper(oracle_username) sname
36: FROM fnd_oracle_userid a,
37: fnd_product_installations b
38: WHERE a.oracle_id = b.oracle_id
39: ORDER BY sname;
40:
547: a.table_name tabname,
548: a.column_name colname,
549: a.partition partname
550: from FND_HISTOGRAM_COLS a,
551: FND_ORACLE_USERID b,
552: FND_PRODUCT_INSTALLATIONS c
553: where a.application_id = c.application_id
554: and c.oracle_id = b.oracle_id
555: order by ownname, tabname, column_name;
560: a.table_name tabname ,
561: a.column_name colname ,
562: a.partition partname
563: FROM FND_HISTOGRAM_COLS a,
564: FND_ORACLE_USERID b ,
565: FND_PRODUCT_INSTALLATIONS c
566: WHERE a.application_id = c.application_id (+)
567: AND c.oracle_id = b.oracle_id (+)
568: ORDER BY ownname,
882: -- leave alone if excluded table
883: AND NOT EXISTS
884: (SELECT NULL
885: FROM fnd_exclude_table_stats fets,
886: fnd_oracle_userid fou ,
887: fnd_product_installations fpi
888: WHERE fou.oracle_username=upper(schemaname)
889: AND fou.oracle_id =fpi.oracle_id
890: AND fpi.application_id = fets.application_id
992: -- leave alone if excluded table
993: AND NOT EXISTS
994: (SELECT NULL
995: FROM fnd_exclude_table_stats fets,
996: fnd_oracle_userid fou ,
997: fnd_product_installations fpi
998: WHERE fou.oracle_username=upper(schemaname)
999: AND fou.oracle_id =fpi.oracle_id
1000: AND fpi.application_id = fets.application_id
1109: )
1110: AND NOT EXISTS
1111: (SELECT NULL
1112: FROM fnd_exclude_table_stats fets,
1113: fnd_oracle_userid fou ,
1114: fnd_product_installations fpi
1115: WHERE fou.oracle_username=upper(schemaname)
1116: AND fou.oracle_id =fpi.oracle_id
1117: AND fpi.application_id = fets.application_id
1382: )
1383: AND NOT EXISTS
1384: (SELECT NULL
1385: FROM fnd_exclude_table_stats fets,
1386: fnd_oracle_userid fou ,
1387: fnd_product_installations fpi
1388: WHERE fou.oracle_username=upper(schemaname)
1389: AND fou.oracle_id =fpi.oracle_id
1390: AND fpi.application_id = fets.application_id
1778: -- leave alone if excluded table
1779: AND NOT EXISTS
1780: (SELECT NULL
1781: FROM fnd_exclude_table_stats fets,
1782: fnd_oracle_userid fou ,
1783: fnd_product_installations fpi
1784: WHERE fou.oracle_username=upper(schemaname)
1785: AND fou.oracle_id =fpi.oracle_id
1786: AND fpi.application_id = fets.application_id
1810: AND di.last_analyzed IS NULL
1811: AND NOT EXISTS
1812: (SELECT NULL
1813: FROM fnd_exclude_table_stats fets,
1814: fnd_oracle_userid fou ,
1815: fnd_product_installations fpi
1816: WHERE fou.oracle_username=upper(schemaname)
1817: AND fou.oracle_id =fpi.oracle_id
1818: AND fpi.application_id =fets.application_id
1899: -- leave alone if excluded table
1900: AND NOT EXISTS
1901: (SELECT NULL
1902: FROM fnd_exclude_table_stats fets,
1903: fnd_oracle_userid fou ,
1904: fnd_product_installations fpi
1905: WHERE fou.oracle_username=upper(schemaname)
1906: AND fou.oracle_id =fpi.oracle_id
1907: AND fpi.application_id = fets.application_id
2021: -- leave alone if excluded table
2022: AND NOT EXISTS
2023: (SELECT NULL
2024: FROM fnd_exclude_table_stats fets,
2025: fnd_oracle_userid fou ,
2026: fnd_product_installations fpi
2027: WHERE fou.oracle_username=upper(schemaname)
2028: AND fou.oracle_id =fpi.oracle_id
2029: AND fpi.application_id = fets.application_id
2267: -- leave alone if excluded table
2268: AND NOT EXISTS
2269: (SELECT NULL
2270: FROM fnd_exclude_table_stats fets,
2271: fnd_oracle_userid fou ,
2272: fnd_product_installations fpi
2273: WHERE fou.oracle_username=upper(schemaname)
2274: AND fou.oracle_id =fpi.oracle_id
2275: AND fpi.application_id = fets.application_id
3056: SELECT a.column_name ,
3057: NVL(a.hsize,254) hsize,
3058: NVL(a.owner, upper(b.oracle_username)) ownname
3059: FROM FND_HISTOGRAM_COLS a,
3060: FND_ORACLE_USERID b ,
3061: FND_PRODUCT_INSTALLATIONS c
3062: WHERE a.application_id = appl_id
3063: AND a.application_id = c.application_id (+)
3064: AND c.oracle_id = b.oracle_id (+)
3181: IS
3182: SELECT DISTINCT a.table_name,
3183: a.application_id
3184: FROM FND_HISTOGRAM_COLS a,
3185: FND_ORACLE_USERID b ,
3186: FND_PRODUCT_INSTALLATIONS c
3187: WHERE
3188: (
3189: b.oracle_username= upper(ownname)
3553: WHERE table_name = upper(tabname)
3554: AND owner =
3555: ( SELECT b.oracle_username
3556: FROM fnd_product_installations a,
3557: fnd_oracle_userid b
3558: WHERE a.application_id = appl_id
3559: AND b.oracle_id = a.oracle_id
3560: );
3561:
3630: BEGIN
3631: SELECT DISTINCT('EXIST')
3632: INTO exist_flag
3633: FROM dba_tab_columns a ,
3634: fnd_oracle_userid b,
3635: fnd_product_installations c
3636: WHERE a.table_name = upper(tabname)
3637: AND a.column_name = upper(colname)
3638: AND c.application_id = appl_id
4593: SELECT DISTINCT('EXIST')
4594: INTO exist_flag
4595: FROM dba_tab_columns a1 , dba_tab_columns a2,
4596: dba_tab_columns a3, dba_tab_columns a4,
4597: fnd_oracle_userid b,
4598: fnd_product_installations c
4599: WHERE a1.table_name = upper(tabname)
4600: AND a2.table_name = upper(tabname)
4601: AND a3.table_name = upper(tabname)
4748:
4749: /*cursor all_histograms(schema varchar2, tableName varchar2) is
4750: select a.column_name
4751: from fnd_histogram_cols a,
4752: fnd_oracle_userid b,
4753: fnd_product_installations c
4754: where a.application_id = c.application_id
4755: and c.oracle_id = b.oracle_id
4756: and b.oracle_username = schema