This discussion is archived
1 Reply Latest reply: Oct 11, 2012 7:24 AM by 967186 RSS

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

967186 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points