Re: data pump
Date: Fri, 5 Apr 2013 08:39:59 +0100
Message-ID: <CAGRZYUdCn4woTmnFW68c7VHyNu5aWnipTwnCytv7TRyHrf8MCQ_at_mail.gmail.com>
Jo
You should be looking at using either SQL*Loader, or external tables, to load data files (eg comma or tab separated text files) into Oracle. This should be much faster (and more convenient) than generating and using insert statements.
SQL Loader: see
http://docs.oracle.com/cd/E14072_01/server.112/e10701/ldr_concepts.htm
External Tables:
http://docs.oracle.com/cd/E11882_01/server.112/e16536/et_concepts.htm
Which approach works best will depend on the details of your situation.
Tanti saluti
Nigel
On 5 April 2013 07:42, jo <jose.soares_at_sferacarta.com> wrote:
> 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
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 05 2013 - 09:39:59 CEST