Re: Extracting data
From: Jeffrey M. Stander <willstand_at_acslink.aone.net.au>
Date: 1996/01/20
Message-ID: <31019320.5D2E_at_acslink.aone.net.au>#1/1
Date: 1996/01/20
Message-ID: <31019320.5D2E_at_acslink.aone.net.au>#1/1
Rick Chruszcz wrote:
>
> Has anybody got an 'unload' script that will unload data from an Oracle
> database into *.dat files and create the *.ctl file at the same time ?
>
When I worked for the CSIRO I wrote one in oraperl that will unload data
to a flat file and also creates a control file to reload it and SQL to
recreate the table.
It is called "unloadr" and should still be available via anon. ftp at
ftp://ftp.ml.csiro.au/software/jstander/oracle_utilities
The software is found in unloadr (plain), unloadr.Z (compressed)
or unloadr.zip (zipped). You will need oraperl to run it.
You'll find other oracle goodies in that directory, too.
Regards,
Jeff Stander