Well, moving indexes into a separate tablespace would also be an
option. The "ALTER INDEX REBUILD" command usually does the trick.
On 2003.07.08 17:54, Seema Singh wrote:
Hi
I observed that following intermedia related tables are growing filling db
fast.
DR$SP_URL_STB_CTX_IDX$I
DR$SCM_DESC_CTX_IDX
Hi
I observed that following intermedia related tables are growing filling db
fast.
DR$SP_URL_STB_CTX_IDX$I
DR$SCM_DESC_CTX_IDX$I
DR$SIT_WIDE_INDEX_CTXIDX$I
I am thinking to drop intermedia indexes and recreate it.Any suggestions?
Thx
-Seema
___
