Re-org Table with LOB segment XML data
Hi all
I do have couple question -doubts about the re-org for tables with LOB segments XML data
i could identify the biggest segments
TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE OWNER MBYTES NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------------------- ------------------------- ------------------ ------------------------------ ---------- ----------- ----------- -----------
ECMX_DEF SYS_LOB0000079914C00006$$ LOBSEGMENT ECOMEX 269917 1 2147483645
ECMX_DEF MSEG TABLE ECOMEX 31036 1 2147483645
ECMX_DEF LIPS TABLE ECOMEX 19246 1 2147483645
ECMX_DEF VBRP TABLE ECOMEX 17391 1 2147483645
ECMX_DEF VBFA TABLE ECOMEX 16429 1 2147483645
ECMX_DEF BKPF TABLE ECOMEX 15972 1 2147483645
and for that biggest segment i could identified the table with that LOB segment
SQL> col COLUMN_NAME for a45
SQL> r