Re: exp dmp converter to text file

"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
>
> 1) I found a nice tool, nxtract,
> (becouse I have only dmp file - a instance of Oracle was gone, and I con't
> use imp), which extract data to txt files, from dmp. But this tool is
> limited to 5000 rows, and I need more, for free ( not a new, doesn't it ? )
>
> So whould somebody give me a direction to tool like nxtract, which could
> read this oracle dmp files ?
>
> 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 Received on Thu Jul 01 2004 - 18:32:26 CEST