RE: Retek Migration

From: Kenneth Naim <kennethnaim_at_gmail.com>
Date: Wed, 8 Jun 2011 14:49:15 -0400
Message-ID: <04df01cc260c$c505b390$4f111ab0$_at_gmail.com>

I’ve migrated databases across endian conversions before using the various methods. I’ve never touched a retek database though so I’m looking for gotchas and best practices so speed up the learning curve.  

Thanks,

Ken  

From: Timo Raitalaakso [mailto:rafu_at_iki.fi] Sent: Wednesday, June 08, 2011 2:52 PM
To: kennethnaim_at_gmail.com
Cc: <oracle-l_at_freelists.org>
Subject: Re: Retek Migration  

1,5TB - it will take some time...  

I have no knowledge of Retek, but when considering endian change take a look for rman

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta018.htm#RCMRF192  

When considering datapump notice network_link option.  

Transportable tablespace is not an option in 10g.  

Seems like sql loader has something for endian change, but your data is allready inside a database.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_field_list.htm#sthref1156

--

Timo Raitalaakso

http://rafudb.blogspot.com

"Kenneth Naim" <kennethnaim_at_gmail.com> kirjoitti 8.6.2011 kello 4.36:

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 08 2011 - 13:49:15 CDT