DBA Hub

📋Steps in this guide1/1

Find tables with LOB seg in DB

set pagesize 200 set lines 200 set long 999 col owner for a15 col table_name for a20 col column_name for a21 select a.owner,a.table_name,a.column_name, data_type from dba_lobs a, dba_tab_columns b where a.column_name=b.column_name and a.table_name = b.table_name and a.owner = b.owner and b.owner not in ('SYS','SYSTEM','DBSNMP','WMSYS');

oracle configurationintermediate
by OracleDba
12 views
1

Find tables with LOB seg in DB

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
set pagesize 200
set lines 200
set long 999
col owner for a15
col table_name for a20
col column_name for a21
select a.owner,a.table_name,a.column_name, data_type
from dba_lobs a, dba_tab_columns b
where a.column_name=b.column_name
and a.table_name = b.table_name
and a.owner = b.owner
and b.owner not in ('SYS','SYSTEM','DBSNMP','WMSYS');

Comments (0)

Please to add comments

No comments yet. Be the first to comment!