Re: Retek Migration

From: Dennis Williams <>
Date: Wed, 8 Jun 2011 10:24:31 -0500
Message-ID: <>


I have no knowledge of Retek, but it seems to me that if your friend has access to a Retek database those questions could be answered. TT has a the dbms_tts.transport_set_check that you can run as a preliminary check.

Whether the vendor stores objects in the system tablespace is tougher, but you probably check ownership of the objects in the system tablespace as a start.

Hope this helps,
Dennis Williams

On Tue, Jun 7, 2011 at 8:36 PM, Kenneth Naim <> wrote:

> A friend of mine is interested in migrating a 10g Retek 1.5tb database
> across platforms that involves and endian change. Has anyone done this, or
> know of white papers addressing this topic? Can it be done via transportable
> tablespaces or does it have to be data pump due to the TT restrictions on
> self-contained tablespaces. Does Retek store objects in the system
> tablespace similar to EBS?
> Thanks,
> Ken

Received on Wed Jun 08 2011 - 10:24:31 CDT

Original text of this message