Re: data pump

From: jo <jose.soares_at_sferacarta.com>
Date: Fri, 05 Apr 2013 08:42:58 +0200
Message-ID: <515E7272.3050404_at_sferacarta.com>

Hi Raj

I realized that my real problem is not on dump, because I can download my database oracle (using cx_Oracle),
large 450 MB,
with 300 tables (1770329 rows)
in about 1 min
and it takes about 7 minutes to upload into postgres

---

my real problem is to upload a database from postgres into Oracle, because it takes about 11 hours (using cx_Oracle) in the format:

INSERT INTO table (column_list) VALUES (values)

I know this format is extremely slow, in fact for Postgres I'm creating the file in format COPY (columns separated by TAB) and this format is much faster than the INSERTs. It takes 7 minutes to upload into postgres a COPY file format an it takes about 1 hour to upload into postgres an INSERTs file format and
It takes about 11 hours to upload into Oracle an INSERTs file format.

Is there a faster way to upload a db into Oracle from a text file ? something similar to postgres' COPY...

j

rjamya wrote:
> 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
>
>
>

-- 
Jose Soares Da Silva                     _/_/
Sferacarta Net
Via Bazzanese 69                       _/_/    _/_/_/
40033 Casalecchio di Reno             _/_/  _/_/  _/_/
Bologna - Italy                      _/_/  _/_/  _/_/
Ph  +39051591054              _/_/  _/_/  _/_/  _/_/
fax +390516131537            _/_/  _/_/  _/_/  _/_/
web:www.sferacarta.com        _/_/_/      _/_/_/

Le informazioni contenute nella presente mail ed in ogni eventuale file allegato sono riservate e, comunque, destinate esclusivamente alla persona o ente sopraindicati, ai sensi del decreto legislativo 30 giugno 2003, n. 196. La diffusione, distribuzione e/o copiatura della mail trasmessa, da parte di qualsiasi soggetto diverso dal destinatario, sono vietate. La correttezza, l’integrità e la sicurezza della presente mail non possono essere garantite. Se avete ricevuto questa mail per errore, Vi preghiamo di contattarci immediatamente e di eliminarla. Grazie.

This communication is intended only for use by the addressee, pursuant to legislative decree 30 June 2003, n. 196. It may contain confidential or privileged information. You should not copy or use it to disclose its contents to any other person. Transmission cannot be guaranteed to be error-free, complete and secure. If you are not the intended recipient and receive this communication unintentionally, please inform us immediately and then delete this message from your system. Thank you.

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

Received on Fri Apr 05 2013 - 08:42:58 CEST