Re: Any tools to unload Oracle data into SQL*Loader format?

From: Maoz Mussel <mmussel_at_iil.intel.com>
Date: 1998/03/12
Message-ID: <350787F7.F6A39DFD_at_iil.intel.com>#1/1


Hi,

You should use the IMP and EXP utilities for this operation. Those are the tools to import data from one database and export into another.

HTH,
Maoz

Michael Wilson wrote:

> I need to be able to unload data from 150+ tables in one database and then
> load them into the same 150+ tables on another database. Is there a tool that
> would unload the data in a format usable by SQL*Loader and optionally, create
> the control file?
>
> Regards,
> Michael
>
> ====== R a y t h e o n S y s t e m s C o m p a n y =====
> Michael Wilson mwilson_at_ti.com
> Member, Group Technical Staff 972-344-2176
> RTIS Information Technology 972-344-3045 (fax)
> Raytheon Systems Company 214-332-5389 (pager)
> ==============================================================
Received on Thu Mar 12 1998 - 00:00:00 CET

Original text of this message