RE: UltraSearch 10g: Moving indexes to new TS, crawler errors, an d robot excluding.

Jesse,

>If this is like my previous Ultra Search posts, I won't hold my breath for
an answer...

I hate to *sort of* dissapoint you ;-) I can reply to at least one part of the question

>much larger than I had expected. While there's no immediate need, =
>should I want to move this to another tablespace, how? I seem to =
>remember that Oracle does not support the movement of some Oracle Text =
>objects, but I'll be darned if I can find info on this.

Since this is 10g, I assume that these objects are located in the new SYSAUX tablespace? If so, then you can look at the V$SYSAUX_OCCUPANTS that lists the occupant, details as well as the procedure to use for moving that type of object under the MOVE_PROCEDURE column. While you cannot move ASH, AWR and other details out of SYSAUX, it seems that you *can* move ULTTRASEARCH objects using the MOVE_WK procedure.

Hth and GL!
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Fear connects you to the Negative, but Faith connects you to the Positive! I Jn 4:18

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

--
http://www.freelists.org/webpage/oracle-l