Re: How Can I .... ?

Mark Davidson <markd_at_pyramid.com> writes:

>I need to somehow 'dump' database table columns into an ascii file and
>then reload that data back into the database. I can't use export
>because I don't want our seqence number (currently messed up). My
>current plan is to use 'select' on the columns and the massage the data
>into the proper 'load' form that we are using. Then reload. Are there
>any other possibilities to do this ??? Any help would be appreciated.
>Thanks.
 

>Mark
>markd_at_pyramid.com

You'll find a number of scripts at the FAQ FTP site

ftp://ftp.bf.rmit.edu.au/pub/Oracle/sources/oraperl2.4/contrib/unloadr
ftp://ftp.bf.rmit.edu.au/pub/Oracle/sources/perl/unloadr.zip
ftp://ftp.bf.rmit.edu.au/pub/Oracle/sources/unloader.zip

--
Oracle FAQ and archives maintainer
orafaq_at_bf.rmit.edu.au                 (private mail to dtb_at_bf.rmit.edu.au)
http://www.bf.rmit.edu.au/OracleFAQ   ftp://ftp.bf.rmit.edu.au/pub/Oracle/
http://www.bf.rmit.edu.au/Oracle      http://www.bf.rmit.edu.au/~orafaq
-- NOT TO BE ARCHIVED IN ANY MANNER ON MICROSOFT NETWORK --