Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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@[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 Thu Apr 05 2001 - 22:20:10 CDT