Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Migrating Oracle data from Mainframe to Unix?

Re: Migrating Oracle data from Mainframe to Unix?

From: <tedchyn_at_yahoo.com>
Date: Thu, 08 Jul 1999 14:29:33 GMT
Message-ID: <7m2cjr$cni$1@nnrp1.deja.com>


johan,
as long as you have your data in text format, you can use sqlloader to load your data. you can use control file to reformat, translate(all oracle function can be used) your mainframe data before loading to oracle.
Ted chyn
In article <7m25a7$75r$1_at_news101.telia.com>,   "Johan Wegener" <xjw_at_xdde.xdk> wrote:
> Hi,
>
> I am interested in hearing whether anybody has got experience in
migrating
> *data* from a mainframe-based Oracle to a Unix-based one?
>
> I'm imagining an exp/imp scenario, EBCDIC to ISO8 character
conversion and
> data volumes in the terrabyte range.
>
> It sounds pretty straightforward, but are there any caveats or
potential
> problems that I must be aware of?
>
> Thanks,
> Johan
> -
> Johan Wegener
> Reply to: xjw_at_xdde.xdk
> NOSPAM: Delete xxx from my email address
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 08 1999 - 09:29:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US