Re: exp dmp converter to text file

"stic" <stefantura_at_klub.chip.pl> wrote in message news:<ccioa4$u83$1_at_news.dialog.net.pl>...
> Uzytkownik "Ed prochak" <ed.prochak_at_magicinterface.com> napisal w wiadomosci
> news:4b5394b2.0407010832.56802f01_at_posting.google.com...
> > "stic" <stefantura_at_klub.chip.pl> wrote in message
> news:<cc0gbf$obp$1_at_news.dialog.net.pl>...
> > > 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 ?
> > 2) get a developer copy of ORACLE, install it, import the dump, then
> > either
> > dump the data as text files (SPOOL, SELECT *) and load PostgreSQL
> > OR
> > transfer from ORACLE to PostgreSQL using something like an ODBC based
> > tool or PERL DBI.
> > Why bother with the hassle of reading a proprietary format? Use the
> > right tool. To real an ORACLE dump it seems to me, the right tool is
> > ORACLE.
> >
> > HTH,
> > ed
> >
> > That would be easier than trying to fiddle with pulling data directly
> > out of the dump file. As the nxtract tool shows, it can be done
>
>
> Hi,
>
> What a nice answer, that is what I'm doing right now.. ;-) Couse I don't
> find any other solution...
> but I can't do it at business proces, where some licences are needed to
> process this data...

My impression was this was a one-time conversion. If this is going to be an ongoing data feed from ORACLE to PostgreSQL, maybe you should renegotiate the interface (have them send flat files instead of an oracle dump). What business process requires using the ORACLE dump format to feed a non-ORACLE DBMS?

> I thought about Oracle Lite, but the exp / imp options doesn't seems to work
> (or I did something wrong, and only on my linux instance these tools aren't
> working ?)

Isn't ORACLE Lite obsolete?
What version of ORACLE did the export come from? (conflict in versions between the ORACLE dump system and Lite?)

If there is a business need for using the dump file format, then there may be a case made to use ORACLE instead of PostgreSQL. Until you contact ORACLE and get a price, you won't know how little that option might cost. Seems like you keep looking for hack solutions instead of engineered solutions.

My company was looking into replacing ORACLE on some systems with MySQL. After checking the upgrade costs for another project, we found the cost was about half the expected cost. MySQL is currently just sitting there, a development, learning, and test tool. All production DB work is in ORACLE.

So next time, tell us the full story of what you are trying to do and why. Then we might have a better chance of answering your question on the first try. Tool versions would help too.

 HTH,
   ed Received on Thu Jul 08 2004 - 19:22:29 CEST