Re: exp dmp converter to text file

Uzytkownik "anacedent" <anacedent_at_hotmail.com> napisal w wiadomosci news: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,
> >>>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
> need to do any export by reading the data directly from Oracle
> and inserting it into PostgreSQL.

I don't have any instance of Oracle (that is my first assume !!), if I have one, there will be no problem to connect them or move data between them...

--
best regards
stic