Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> export with conditions

export with conditions

From: Kathinka Diehl <kathinka_at_rrr.de>
Date: Mon, 29 Nov 1999 12:17:44 +0100
Message-ID: <81tnmu$250fj$1@fu-berlin.de> 





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


Received on Mon Nov 29 1999 - 05:17:44 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US