1 Reply Latest reply: Oct 11, 2012 9:24 AM by 967186 RSS

    anybody help me how to calculate the size of table with xmltype column.

    967186
      Hello I have table with below structure ,but if I query dba_segments the tablepace is 2gb but where as the path table and secondary indexes are huge around 20G seems I am not querying the size of xmltupe..Please help me how I can calucute the size of below table.


      CREATE TABLE DAS_DESC.DESCRIPTION
      (
      NAID NUMBER,
      P_NAID NUMBER,
      DESC_TYPE VARCHAR2(200 BYTE),
      XML_DATA SYS.XMLTYPE,
      RECORD_KEY NUMBER
      )
      XMLTYPE XML_DATA STORE AS BASICFILE BINARY XML