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 -> import/export: use of sqlldr??.exe

import/export: use of sqlldr??.exe

From: Michiel <cube_at_REMOVE.dds.nl>
Date: Fri, 4 May 2001 22:24:19 +0200
Message-ID: <3af3108b$0$27218@reader4>

Hi,

On Win9x or WinNT is it possible to export data using sqlldr73.exe or sqlldr80.exe with a where clause or a creation_date stamp?

thing is:
I must export data with some time stamp (column in table), I know I can create some fancy archive script (which is no pronlem), but I guess that will be less efficient than using some specific export tools

the script(s) needed are either packages or NT scripts. note: there's also the need of import scripts, but since they will be used rarely, they are allowed to be slow.
note: there are about 100 tables, in which 10% of that tables have 10 million of records of which 10% will be exported.

Does anyone have some tips on handling this?

thnx in advance,
Michiel Received on Fri May 04 2001 - 15:24:19 CDT

Original text of this message

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