Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Extracting data directly from Export file?

0 views
Skip to first unread message

David Diano

unread,
Apr 5, 1999, 3:00:00 AM4/5/99
to
We exported a database with some very large Tables (even for Oracle)
and cannot import the tables back into an instance. (Don't ask why, part
of answer involves Oracle bug for which we didn't have the patch.)
We would like to be able to run some program that would extract a
single table from the EXPORT file and just dump it into a simple TEXT
file (rather that import it back to Oracle). Once the data has been
dumped into a single text file, we can break it up into smaller pieces
or use an editor to solve any remaining problems.

Is there a utility program that can read/extract data directly from an
Oracle EXPORT file? (I would think this would a very useful tool to
have, so someone might have already created one or know where Oracle may
have hidden it.)

Thanks in advance,
David Diano

Ronald

unread,
Apr 6, 1999, 3:00:00 AM4/6/99
to

On Tue, 6 Apr 1999 4:39:30 +0200, David Diano wrote
(in message <370973E2...@diano.com>):

Hi David

this is why I wrote expload. It's no click and point tool and it's far from
ready or polished. It is usable if you know c. Someone has already used it to
correct a corrupted expdat.dmp file.

You can get the code if you like.
--
The best way to accellerate a computer running windows is at 9.8 m/s^2


0 new messages