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 -> Re: Q: Oracle exp dump files

Re: Q: Oracle exp dump files

From: RonR <ronr_at_my-deja.com>
Date: Wed, 5 Jan 2000 10:40:32 +0100
Message-ID: <01HW.B498D020002E7C740F82552C@news.planet.nl>


On Tue, 4 Jan 2000 18:12:51 +0100, L Lamburt wrote (in message <38722A13.976CBEAF_at_gte.com>):

> Hello,
>
>
> Does anyone know about any tool that allows
> to extract data directly from the dump files produced by
> Oracle exp utility?
>
>
>

I wrote expload to do that. The internal formats are not documented and I did not decode all formats. Only date,number, char and varchar. Maybe a fast unload program is a better solution ... For this I also made fun, a little piece of proc dynamic sql that performs array fetches for any given table and creates sqlloader data and control files.

--
Ronald.



http://home.wxs.nl/~ronr/RonR.html
The best way to accellerate a computer 'running' windows is by gravitation. Received on Wed Jan 05 2000 - 03:40:32 CST

Original text of this message

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