Re: data pump
- From: jo <jose.soares@xxxxxxxxxxxxxx>
- Date: Fri, 05 Apr 2013 16:48:52 +0200
SQL*Load is great, it uploads an entire database in a few minutes.
Faster than Postgres.
But I'm yet fighting with dates style.
I need to insert dates with iso style yyyy-mm-dd but oracle wants it in
the format dd-mon-yy
I tried to set environment
export set nls_timestamp_format='YYYY-MM-DD HH24:MI:SS.FF'
export set nls_timestamp_tz_format='YYYY-MM-DD HH24:MI:SS.FFTZD'
export set nls_date_format='YYYY-MM-DD'
without success
in sql*plus I can do:
alter session set nls_timestamp_format = "YYYY-MM-DD HH24:MI:SS.FF";
alter session set nls_timestamp_tz_format = "YYYY-MM-DD HH24:MI:SS.FFTZD";
alter session set nls_date_format = "YYYY-MM-DD";
but I don't know how to change date style in sql*load
any hint?
j
rjamya wrote:
> Oh yes, as Nigel said, if you create a proper delimited file, you can
> create independent sqlloader control files, you can fire them off in
> parallel. Much much better than individual insert statements. Use direct
> path option and load even faster.
> If you want to add data transformation while loading raw data? see if you
> can use external table interface. For large files, split them (i use unix
> split command), and then use parallel option.
>
> If you are loading into an empty db, it might make sense to drop indexes,
> disable constraints and after load add indexes and re-enable constraints.
> and dont forget stats :)
>
> Raj
>
>
> On Fri, Apr 5, 2013 at 2:42 AM, jo <jose.soares@xxxxxxxxxxxxxx> wrote:
>
>
>> my real problem is to upload a database from postgres into Oracle, because
>> it takes about 11 hours (using cx_Oracle)
>>
>>
>
>
>
>> 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...
>>
>>
>
>
> --
> //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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
