Re: data pump

From: Amaral, Rui <Rui.Amaral_at_tdsecurities.com>
Date: Thu, 4 Apr 2013 08:29:31 -0400
Message-ID: <CC45762506E4C84A8612307613CDCB2566A1E7C0_at_EX7T2-SV08.TDBFG.COM>

Another option maybe... Use foreign data wrappers in postgres to pull from oracle?- similar to a dblink.

• Original Message ----- From: rjamya [mailto:rjamya_at_gmail.com] Sent: Thursday, April 04, 2013 08:18 AM To: jose soares <jose.soares_at_sferacarta.com> Cc: ORACLE-L <oracle-l_at_freelists.org> Subject: Re: data pump

no text file using datapump ... it is always in custom binary format. You can use data unloader at www.jaredstill.com to create csv and load with your favorite loader for postgres. or you can roll your own plsql code to unload data in other needed format.
Raj

On Thu, Apr 4, 2013 at 4:19 AM, jo <jose.soares_at_sferacarta.com> wrote:

>
> I'm trying to dump an oracle database to load into postgres using expdp
> but the result output file is a binary file. Is there a way to create a
> text file instead?
>

--
http://www.freelists.org/webpage/oracle-l



NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au www.td.com/francais/avis_juridique pour des instructions.
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 04 2013 - 14:29:31 CEST