Ken, If nobody on this list supports Retek, I notice that there is a Usenet Newsgroup for Retek. Dennis On Wed, Jun 8, 2011 at 11:38 AM, Kenneth Naim <kennethnaim@xxxxxxxxx> wrote: > 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. > > > > Thanks, > > Ken > > > > *From:* Dennis Williams [mailto:oracledba.williams@xxxxxxxxx] > *Sent:* Wednesday, June 08, 2011 11:25 AM > *To:* kennethnaim@xxxxxxxxx > *Cc:* oracle-l@xxxxxxxxxxxxx > *Subject:* Re: Retek Migration > > > > Ken, > > > > 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 <kennethnaim@xxxxxxxxx> > 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 > > >