Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import/export: use of sqlldr??.exe
"Michiel" <cube_at_REMOVE.dds.nl> wrote in message
news:3af3108b$0$27218_at_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
>
>
>
sql*loader imports O/S files, consequently it can't export.
I would probably export to ascii using TOAD (free version at
http://www.toadsoft.com ) which definitely can do an ascii export using a
where clause, and import using sqlldr as that has direct mode and TOAD
definitely doesn't have that.
OTOH you could of course always dump the entire table to ascii, and have
Sql*loader discard unnecessary records.
Just a few ideas...
Hth,
Sybrand Bakker, Oracle DBA Received on Fri May 04 2001 - 16:22:01 CDT