RE: UltraSearch 10g: Moving indexes to new TS, crawler errors, an d robot excluding.
- From: John Kanagaraj <john.kanagaraj@xxxxxxx>
- To: "'Rich.Jesse@xxxxxxxxxxxxxxxxx'" <Rich.Jesse@xxxxxxxxxxxxxxxxx>, "ORACLE-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Mar 2005 11:27:45 -0800
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 **
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: UltraSearch 10g: Moving indexes to new TS, crawler errors, an d robot excluding.
