[Home] [Help]
1778: -- bug1301043.
1779: --
1780: cursor grants_cursor is
1781: (select table_name object_name, 'TABLE ' object_type
1782: from dba_tables
1783: where owner= upper(base_schema)
1784: and iot_name is null
1785: and table_name not like '%$%'
1786: minus
1795: and sequence_name not like '%$%';
1796:
1797: cursor synonyms_cursor is
1798: Select Nvl(Ev.View_Name,Tab.Table_Name) Target_name, Tab.table_name object_name, 'TABLE ' object_type
1799: From Dba_Tables Tab
1800: Left Outer Join
1801: Dba_Editioning_Views Ev
1802: On (Tab.Table_Name=Ev.table_Name)
1803: Where Tab.Owner=Nvl(Ev.Owner, Tab.Owner)
2430: if create_mls_views then
2431: -- work on tables that are multilingual
2432: statement := 'select distinct upper(atc.table_name) '||
2433: 'from '||aol_schema||'.ak_translated_columns atc,'||
2434: ' dba_tables dt '||
2435: 'where dt.table_name = upper(atc.table_name) '||
2436: 'and nvl(atc.enabled_flag,''Y'') = ''Y'' '||
2437: 'and dt.owner = :table_schema ';
2438: else