Re: export with conditions

A copy of this was sent to "Kathinka Diehl" <kathinka_at_rrr.de> (if that email address didn't require changing) On Mon, 29 Nov 1999 12:17:44 +0100, you wrote:

>I have to export a part of a table. This table has more then 60.000.000 rows
>and I need just for example the last 10.000 rows.
>
>Import with SQLLoader could contain conditions, but is there a possibility
>for Export?
>
>It seems to me now, the only way to solve this problem is to write the datas
>with spool and select into an txt-file and import this one afterwards with
>the SQLLoader. But this takes a lot f time. Is there a more convienent way?
>
>Thx in advance
>Kathinka
>

You don't mention a version but in Oracle8i release 8.1 you can put a predicate on an export with the "QUERY=" parameter.

You could CREATE TABLE AS SELECT to get the 10k rows you want and then export that as well.

--
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 Mon Nov 29 1999 - 07:43:41 CST