RE: Retek Migration

From: Kenneth Naim <>
Date: Wed, 8 Jun 2011 12:38:04 -0400
Message-ID: <04b601cc25fa$71a8c780$54fa5680$>

He doesn't have access yet, so we are just trying to do as much research as possible so we can hit the ground running if/when we do get access. I know EBS has a platform migration document that covers the sys objects I was hoping for a similar one either by oracle or others for retek.  



From: Dennis Williams [] Sent: Wednesday, June 08, 2011 11:25 AM
Subject: Re: Retek Migration  


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?  



Received on Wed Jun 08 2011 - 11:38:04 CDT

Original text of this message