Re: Export limited number of rows

"Ernst Breivik" <Ernst-Hugo.Breivik_at_telenor.com> wrote in message news:<7Aaw9.1873$Hb.98073_at_news2.ulv.nextra.no>...
> Hi.
>
> Is it possible to do an export of a table and limit the number of rows to
> say 100?
>
> E Breivik

Well, I'm not sure if this is applicable but what I've done in the past is to:

    create table my_table_copy as select * from my_table     where rownum <= 100;

  ... and then to export that.

   I've done this when sizing a table and want to get an idea of the affects of a setting such pctfree is going to affect things.

hth Received on Thu Oct 31 2002 - 20:42:01 CET