Oracle Text Indexes

I am on Oracle 10.2.0.3 and using Oracle text (and not Oracle intermedia text.). This a third party package so I have no control. There several text indexes of index_type domain.

1. When I look in user_indexes stable it shows me two indexes for a text index X_TEXT_OBJECT_VALUE:

X_TEXT_OBJECT_VALUE DOMAIN
DR$X_TEXT_OBJECT_VALUE$X NORMAL I do not understand what is this DR$ index.

2. When I run command:
alter index X_TEXT_OBJECT_VALUE rebuild;

Command runs successfully, but when I look at last_analyzed select index_name, index_type, last_analyzed from user_indexes where index_name like '%X_TEXT_OBJECT_VALUE%';

It does not show me any value in last_analyzed, why? I tried to explicitly analyze:
DR$X_TEXT_OBJECT_VALUE$X , that also did not change the last_analyzed. Why?

I tried some other indexes, there last_analyzed is updated, so not sure when last_analyzed is updated and when it is not updated.

Thanks in advance, any pointers will be appreciated. Received on Mon May 19 2008 - 16:13:38 CDT