Re: Transportable tablespaces

From: Chuck <skilover_nospam_at_softhome.net>
Date: 9 Nov 2004 14:17:10 GMT
Message-ID: <Xns959C5E76DDA63skiloversofthomenet@130.133.1.4>

Mladen Gogala <gogala_at_sbcglobal.net> wrote in news:pan.2004.10.18.11.45.38.855414_at_sbcglobal.net:

> On Sat, 16 Oct 2004 12:47:55 -0400, Vikas Agnihotri wrote:
>

>> Has anyone used the transportable tablespace feature in 9.2.0.4?
>> 
>> I am trying to run the dbms_tts.transport_set_check() API specifying 2 
>> tablespaces. Total of about 100 objects, no IOTs, no LOBs, no 
>> partitioned tables.
>> 
>> The API takes 50 minutes to run! When I trace it, I see the following 
>> stand out

>
> Vikas, do you have sys schema analyzed? I noticed that if the sys schema
> was analyzed. The problem is that dictionary selects wrong join path. In
> 9.2.0.4 you shouldn't analyze data dictionary. In 9.2.0.5 this thing was
> gone.
>

Are you saying it's ok to analyze the data dictionary in 9.2.0.5. I have not tried this since doing it accidentally once back in 8.something with awful results. Does Oracle have any recommendations on this? Received on Tue Nov 09 2004 - 08:17:10 CST