Re: Exporting Portion of a table alone

From: TurkBear <johng_at_nospam.mm.com>
Date: Fri, 02 Oct 1998 21:33:33 GMT
Message-ID: <36174666.28221039@news2.mm.com>

"Vimalesan" <vthangavel_at_lucent.com> wrote:

>HI,
>
>I need to export only portion of the exting table (either first 5000 rows
>or last 5000 rows)
>only (this is because of the performance problem).
>
>As and when required i can go ahead and import those rows.
>
>Is there any option or idea to export portion of the table with any
>condition?.
>
>Thanks
>Vimal

If possible, create a temporary table with the rows you need( select * from table where rownum < 5001 ) and export that...

To reply please remove the 'nospam' part of the address Received on Fri Oct 02 1998 - 16:33:33 CDT