DBA Data[Home] [Help]

APPS.AD_LONGTOLOB_PKG dependencies on DBA_SEGMENTS

Line 806: FROM dba_tab_columns a, dba_segments b

802: l_To_DataType_Tbl To_DataType_Tbl_Type;
803:
804: CURSOR c1(p_Table_Name VARCHAR2 ) IS
805: SELECT table_name, column_name, a.owner, data_type, bytes/1024/1024 t_size
806: FROM dba_tab_columns a, dba_segments b
807: WHERE data_type IN ('LONG', 'LONG RAW')
808: AND table_name = p_Table_name
809: AND segment_name = table_name
810: AND a.owner NOT IN ('SYS','SYSTEM','OUTLN')