Wednesday 10 July 2013

ORACLE: finding tables with LOBSEGMENTS in them

I'm prepping to migration a SAP system on an ORACLE database
As part of this I find that some of the biggest segments in the database are LOBSEGMENTs
How do you find what table they are part of?

select table_name from dba_lobs where SEGMENT_NAME=’’;

Hope that comes in handy...

No comments:

Post a Comment