Re: Does A Partial Table Extract Utility Exist

Thanks.
In article <2lbzNxQsReuL=P+9pn+nY8C1BrTS_at_4ax.com>,   tkyte_at_us.oracle.com wrote:
> 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.
>
> 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 30 1999 - 16:25:35 CEST