Re: Move data from production schema to development schema which has some modifications
From: gazzag <gareth_at_jamms.org>
Date: Tue, 19 Jan 2010 07:26:32 -0800 (PST)
Message-ID: <c22558b0-2db2-4930-a0ee-2cba71e49602_at_v25g2000yqk.googlegroups.com>
On 19 Jan, 15:03, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
>
> Oracle also provideds the sqlldr utility which is described in the
> same manual gazzag referenced, to load delimited or fixed position
> data into database tables from flat files. The Oracle External table
> feature is basically a means to execute sqlldr from within the
> database.
>
> If you need to move data into Oracle from a non-Oracle source you may
> find sqlldr handy.
Date: Tue, 19 Jan 2010 07:26:32 -0800 (PST)
Message-ID: <c22558b0-2db2-4930-a0ee-2cba71e49602_at_v25g2000yqk.googlegroups.com>
On 19 Jan, 15:03, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
>
> Oracle also provideds the sqlldr utility which is described in the
> same manual gazzag referenced, to load delimited or fixed position
> data into database tables from flat files. The Oracle External table
> feature is basically a means to execute sqlldr from within the
> database.
>
> If you need to move data into Oracle from a non-Oracle source you may
> find sqlldr handy.
Good point, Mark. The OP may also find Oracle's Heterogeneous Connectivity useful too:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14232/toc.htm
>
> HTH -- Mark D Powell
HTH
-g
Received on Tue Jan 19 2010 - 09:26:32 CST