Re: exp dmp converter to text file

From: stic <stefantura_at_klub.chip.pl>
Date: Thu, 8 Jul 2004 08:14:35 +0200
Message-ID: <cciopj$vhh$1_at_news.dialog.net.pl>


[Quoted] [Quoted] Uzytkownik "Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> napisal w wiadomosci news:3uqde09j3b7nd4mhtr57eue4tfel9l3649_at_4ax.com...
> On Thu, 1 Jul 2004 10:01:27 +0200, "stic" <stefantura_at_klub.chip.pl>
> wrote:
> >Hi,
> >I need to convert Oracle database from exp file to PostgreSQL database,
so
> >what I do is to:
> >1) convert this dmp file to txt
> >2) import this file to PostgreSQL
> >2) Or there is direct way to import Oracle file to PostgreSQL ?
> Toad will export to ascii files with insert commands.
> IIRC this functionality is already present in the free version at
> www.toadsoft.com
> --
> Sybrand Bakker, Senior Oracle DBA

[Quoted] Yes, that is the solution - for my ca.250MB file this work all night (with these inserts) but IT WORKS ! ;-)
[Quoted] Now there is a question, is TOra supportiong this operation ? Sorry for such a simple questions, but I have no xp with this software...

--
best regards
stic
Received on Thu Jul 08 2004 - 08:14:35 CEST

Original text of this message