One of my application is using XMLTYPE as datatype and storing CLOB as sorage with maxxtent as 1024 .Now the extent is going to be full and I need to resize .I am trying to figure it out the column name for LOBSEGMENTS which is extent 95% fulll .I have tried from DBA_LOBS and it is showing column name as SYS_ somrthing not the original column name . How do I find out the COLUMN Name for the LOBSEGMENTS whih is extent full ?
I have searched a lot and not able identify this .
Storage clause for columns :
XMLTYPE COLUMN "AGENT_INFO_XML" STORE AS CLOB (
TABLESPACE "<tablespacename>" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
STORAGE(INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 1024
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
The segment which extent is going to be full : COLUMN NAME is NOT SHOWING .It is 11.2.3 database .
SQL> select TABLE_NAME,COLUMN_NAME,SEGMENT_NAME,TABLESPACE_NAME,CHUNK from dba_lobs where SEGMENT_NAME='SYS_LOB0000034131C00071$$';