Re: Data Loading from Informix to Oracle
From: sybrandb <sybrandb_at_gmail.com>
Date: 16 Oct 2006 03:24:13 -0700
Message-ID: <1160994253.883694.321200_at_m73g2000cwd.googlegroups.com>
Date: 16 Oct 2006 03:24:13 -0700
Message-ID: <1160994253.883694.321200_at_m73g2000cwd.googlegroups.com>
Nick wrote:
> Hi,
> I need to load millions of data from Informix 7.3 to Oracle9i.
> I was thinking of using Sql loader to load the data so the data from
> informix should come come in as a flat file .
> For eg a CSV file now the flat file has a restriction on its size when
> the data is huge i doubt if its going to truncate the data which means
> i don't get the entire data on a CSV file..
>
> Please advice me on this .
>
> Thanks
try splitting the dump from Informix into several dumps using range criteria. Obviously the Informix database is preferably not in use during dumping.
Hth
-- Sybrand Bakker Senior Oracle DBAReceived on Mon Oct 16 2006 - 12:24:13 CEST