Re: What is domain index?

A domain index is a text index (intermedia if you are on 8i, context if you are on an earlier version). You may be looking at the 'marker' for the index. An actual text/domain index will be comprised of at least 4 tables in the users' schema...check for naming conventions like DR$index_name$I, $K,$R and $N ...
<u132781982_at_spawnkill.ip-mobilphone.net> wrote in message news:l.986419764.1096130371_at_[198.138.198.252]...
> One of my user created some index at system
> tablespace, but when I try to
>
> alter index joe.COUNTY_QTREE rebuild tablespace indx;
> I got
>
> ERROR at line 1:
> ORA-29871: invalid alter option for a domain index
>
>
> Could someone tell me what is domain index and how
> I can relocate them to another tablespace?
>
> Thanks
>
>
>
>
>
> --
> Sent by dbadba62 from hotmail subdomain of com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
>
Received on Fri Apr 06 2001 - 05:20:10 CEST