Re: How to unload data from a table

Oracle does not provide a tool that will directly unload a table to a flat file. If your requirement only involves moving data from one Oracle DB to another, then you can utilize EXP/IMP to physically get the data from one place to another, then utilize the SQL*PLUS COPY command to create a new object that is a subset of the rows/columns from the original table.

In fact, if your machine(s) are using SQL*Net, there is no need to use EXP/IMP. You can simply execute the SQL*Plus COPY command over the network.

If your requirement involves non-Oracle databases, then you would likely need to roll your own using Pro*C or the OCI interfaces.

Hope this helps.

In article <4h06uv$bun_at_news.nznet.gen.nz>, slc_at_stevensons.co.nz says...
>
>What's the easiest way unload some data from a table to a
>text file, that could then be loaded in another database or
>table via SQL*Loader.
>
>With Informix you can say:
>unload to "filename" select ...
>
>The rows & columns returned by the select statement
>would be stored in pipe-delimitered format in the specified
>file.
>
>Is there a similar facility in Oracle 7? I'm not sure if the
>"exp" and "imp" utilities are suitable, because I might
>not require all rows or columns from the source table.
>
>Any help much appreciated. Please reply via email.
>
>Steve Chell
>slc_at_stevensons.co.nz
>
>
Received on Sun Mar 03 1996 - 00:00:00 CET