Re: Transportable tablespaces

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 18 Oct 2004 07:45:39 -0400
Message-ID: <pan.2004.10.18.11.45.38.855414@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.

-- 
Artificial Intelligence is no match for natural stupidity.

Received on Mon Oct 18 2004 - 06:45:39 CDT