RE: Retek Migration
- From: "Kenneth Naim" <kennethnaim@xxxxxxxxx>
- To: "'Timo Raitalaakso'" <rafu@xxxxxx>
- Date: Wed, 8 Jun 2011 14:49:15 -0400
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@xxxxxx]
Sent: Wednesday, June 08, 2011 2:52 PM
To: kennethnaim@xxxxxxxxx
Cc: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx> 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
Other related posts:
