Re: exp dmp converter to text file

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

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