space of context index and CLOB table

From: <hosu_at_cs.umbc.edu>
Date: Sun, 31 Dec 2000 07:36:07 GMT
Message-ID: <92mnl7$mbn$1@nnrp1.deja.com>

Hi, there,

I am searching similar question on the above question, and find some helpful. Here is my very specific question:

How can I calculate the space of interMedia text index?

e.g.:

CREATE TABLE CLOBTABLE
(ID NUMBER PRIMARY KEY,
DOCUMENT CLOB); CREATE INDEX CLOBINDEX ON CLOBTABLE(DOCUMENT) INDEXTYPE IS CTXSYS.CONTEXT; There seems to have some dynamic table, is there any way that I can get the total space which is associate with the context index CLOBINDEX.

Besides for the table CLOBTABLE, which has one column of CLOB, how can I figure out the total space for the table?

Thank you and happy new year!

Honglin

Sent via Deja.com
http://www.deja.com/ Received on Sun Dec 31 2000 - 01:36:07 CST