Re: Does A Partial Table Extract Utility Exist

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 30 Sep 1999 08:26:36 -0400
Message-ID: <2lbzNxQsReuL=P+9pn+nY8C1BrTS_at_4ax.com>


[Quoted] A copy of this was sent to lefty300_at_my-deja.com (if that email address didn't require changing) On Tue, 28 Sep 1999 20:58:11 GMT, you wrote:

>Does anyone know of an inexpensive unload utility that can unload a
>subset of rows from a table? I used to work with DB2 on MVS and used
>a nice utility called DSNTIAUL that was shipped with DB2. This utility
>could be setup to use SQL statements to identify the columns and rows
>you wanted, or just a table name to unload a complete table.
>It also created the load control cards. Currently we are using sqlplus
>and spooling the output to a file. The table has about 250K rows and has
>a LONG column.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

[Quoted] In Oracle8i, release 8.1, the export utility supports a "where clause" to subset the rows it will export.

-- 
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Thu Sep 30 1999 - 14:26:36 CEST

Original text of this message