Re: exp dmp converter to text file

From: anacedent <anacedent_at_hotmail.com>
Date: Thu, 08 Jul 2004 17:14:24 -0700
Message-ID: <BrlHc.2682$ys.2457_at_fed1read03>

stic wrote:
> 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
>

[Quoted] >>>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

>
>
> Yes, that is the solution - for my ca.250MB file this work all night (with
> these inserts) but IT WORKS ! ;-)
> 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
>
>
Alternatively throw together some PERL code which eliminates the [Quoted] need to do any export by reading the data directly from Oracle and inserting it into PostgreSQL. Received on Fri Jul 09 2004 - 02:14:24 CEST