[Home] [Help]
443: where s.table_name = p.synonym_name
444: and s.table_owner = p.owner
445: and s.table_owner in
446: ( select oracle_username
447: from system.fnd_oracle_userid
448: where read_only_flag in ('A','B', 'E', /*'U',*/ 'C')
449: )
450: )
451: cycle owner, synonym_name set cyclemarker to 'Y' default 'N'
606: CURSOR c_trg is
607: select owner, trigger_name, trigger_type, status
608: from dba_triggers
609: where table_owner in
610: ( select oracle_username from system.fnd_oracle_userid
611: where read_only_flag in ('A','B', 'E', 'U', 'C') )
612: -- EXCLUDE: trigger generated by the Oracle Text Indexing
613: and trigger_name not like 'DR$%'
614: -- EXCLUDE: Editioned Data Storage Maintenance Trigger Name
622: or
623: (table_name=ev_view(x_table_name) and base_object_type='VIEW')
624: )
625: and owner in
626: (select oracle_username from system.fnd_oracle_userid
627: where read_only_flag in ('A','B', 'E', 'U', 'C') );
628:
629: begin
630: log(C_MODULE, 'PROCEDURE', 'begin: '||x_table_owner||'.'||x_table_name);
922: cursor c_dependents (p_synonym_name varchar2) is
923: select distinct d.owner --, d1.name, d1.type
924: from dba_dependencies d
925: where d.owner in ( select oracle_username
926: from system.fnd_oracle_userid
927: where read_only_flag in ('A','B', 'E', 'U', 'C' )
928: )
929: and d.referenced_type = 'SYNONYM'
930: and d.referenced_owner = 'PUBLIC'
974: from dba_synonyms syn,
975: DBA_TABLES tab
976: where syn.owner='PUBLIC'
977: and syn.table_owner in ( select oracle_username
978: from system.fnd_oracle_userid
979: where read_only_flag in ('E', 'A', 'B', 'C')
980: )
981: and syn.table_owner = x_table_owner
982: and syn.table_name = x_table_name
1127: where syn.table_owner = x_table_owner
1128: and syn.table_name in (x_table_name, x_ev_name)
1129: and syn.owner in
1130: ( select oracle_username
1131: from system.fnd_oracle_userid
1132: where read_only_flag in ('A','B', 'E', 'U', 'C') );
1133:
1134: begin
1135: log(c_module, 'PROCEDURE', 'begin: '||X_TABLE_OWNER||'.'||X_TABLE_NAME);
1251: tab.owner table_owner
1252: , tab.table_name table_name
1253: from dba_tables tab
1254: where tab.owner in
1255: ( select oracle_username from system.fnd_oracle_userid
1256: where read_only_flag in ('A','E','B') )
1257: and tab.temporary = 'N'
1258: and tab.secondary = 'N'
1259: /* not an application-managed dynamic table */
1302: ( select
1303: fou.oracle_username owner
1304: , aoo.object_name object_name
1305: from
1306: system.fnd_oracle_userid fou
1307: , fnd_product_installations fpi
1308: , ad_obsolete_objects aoo
1309: where fpi.application_id = aoo.application_id
1310: and fou.oracle_id = fpi.oracle_id
1320: cursor C_REUPGRADE_TABLES is
1321: select ev.owner table_owner, ev.table_name
1322: from dba_editioning_views ev
1323: where ev.owner in
1324: ( select oracle_username from system.fnd_oracle_userid
1325: where read_only_flag in ('A','E','B') )
1326: and ( exists /* uncoverted synonyms */
1327: ( select syn.synonym_name
1328: from dba_synonyms syn
1326: and ( exists /* uncoverted synonyms */
1327: ( select syn.synonym_name
1328: from dba_synonyms syn
1329: where syn.owner in
1330: ( select oracle_username from system.fnd_oracle_userid
1331: where read_only_flag in ('A', 'B', 'C', 'E', 'U') )
1332: and syn.table_owner = ev.owner
1333: and syn.table_name = ev.table_name ) or
1334: exists /* unmoved triggers */
1334: exists /* unmoved triggers */
1335: ( select trg.trigger_name
1336: from dba_triggers trg
1337: where trg.owner in
1338: ( select oracle_username from system.fnd_oracle_userid
1339: where read_only_flag in ('A', 'B', 'C', 'E', 'U') )
1340: and trg.trigger_name not like '%$%' /* system trigger */
1341: and trg.crossedition = 'NO'
1342: and trg.table_owner = ev.owner
1932: cursor c_ood_indexes(x_table_owner varchar2, x_table_name varchar2) is
1933: select idx.owner, idx.index_name, idx.index_type, idx.partitioned
1934: from dba_indexes idx
1935: where idx.owner in
1936: ( select oracle_username from system.fnd_oracle_userid
1937: where read_only_flag in ('A', 'B', 'E', 'U') )
1938: and idx.owner = idx.table_owner
1939: and idx.table_owner = x_table_owner
1940: and idx.table_name = x_table_name
2027: dba_indexes ridx
2028: , dba_indexes oidx
2029: , dba_constraints con
2030: where ridx.owner in
2031: ( select oracle_username from system.fnd_oracle_userid
2032: where read_only_flag in ('A', 'B', 'E', 'U') )
2033: and ridx.table_owner = x_table_owner
2034: and ridx.table_name = x_table_name
2035: and regexp_like(ridx.index_name, ad_zd_table.revised_index_regexp, 'c')
2197: , dba_tab_columns col
2198: , dba_editioning_views ev
2199: where tab.owner in
2200: ( select oracle_username
2201: from system.fnd_oracle_userid
2202: where read_only_flag in ('A','E','B') )
2203: and col.owner = tab.owner
2204: and col.table_name = tab.table_name
2205: and col.owner = x_owner
2313: from dba_tab_columns col
2314: , dba_editioning_views ev
2315: where ev.owner in
2316: ( select oracle_username
2317: from system.fnd_oracle_userid
2318: where read_only_flag in ('A','E','B')
2319: )
2320: and ev.owner = nvl(x_table_owner, col.owner)
2321: and ev.table_name = nvl(x_table_name, col.table_name)
2338: select ev.owner, ev.table_name
2339: from dba_unused_col_tabs uct, dba_editioning_views ev
2340: where uct.owner in
2341: ( select oracle_username
2342: from system.fnd_oracle_userid
2343: where read_only_flag in ('A','E','B') )
2344: and uct.owner = nvl(x_table_owner, uct.owner)
2345: and uct.table_name = nvl(x_table_name, uct.table_name)
2346: and ev.owner = uct.owner
2397: from
2398: dba_indexes idx
2399: , dba_constraints con
2400: where idx.owner in
2401: ( select oracle_username from system.fnd_oracle_userid
2402: where read_only_flag in ('A', 'B', 'E', 'U') )
2403: and regexp_like(idx.index_name, ad_zd_table.revised_index_regexp, 'c')
2404: and con.owner(+) = idx.table_owner
2405: and con.table_name(+) = idx.table_name
2412: from dba_tab_columns col
2413: , dba_editioning_views ev
2414: where col.owner in
2415: ( select oracle_username
2416: from system.fnd_oracle_userid
2417: where read_only_flag in ('A','E','B') )
2418: and col.nullable = 'N'
2419: and col.table_name not like '%#'
2420: and (col.default_length is null or col.default_length = 4)