Oracle Database Discussions

Hi,

I have  a table with CLOBs as follows:

SQL> desc INFO_MESSAGES

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

CLNT_OID                                NOT NULL VARCHAR2(16)

USR_OID                                  NOT NULL VARCHAR2(16)

LAST_client_msg_ID                                VARCHAR2(36)

LAST_client_msg_DATE                              DATE

LAST_client_msg                                   CLOB

LAST_USR_MSG_BOD_ID                               VARCHAR2(36)

LAST_USR_MSG_DATE                                 DATE

LAST_USR_MSG                                      CLOB

Now I want to find what is the total size/space taken up by the table (including the CLOB columns), then how do I find it? I think the usual command doesnt work - the

select size from dba_segments where segment_name='INFO_MESSAGES' is only showing 7 MB whereas I think the table has several GB of space due to the clobs.

Also to add one more detail: when quering dba_segments I see an output like this:

select * from dba_segments order by bytes desc;

MIGRTN SYS_LOB0000111131C00008$$ LOBSEGMENT ASSM DATA1 6 20690 119013376000 14528000 1963 <--the top row

Here MIGRTN is the schema where this INFO_MESSAGES table is present.

Thansk,

OrauserN