Loading into Oracle Tables
Posted: Thu Sep 24, 2009 9:12 am
Hi Experts,
My requirement loading huge amout of data into Orcle (10g) tables.
running on AIX 7.5 server edition.
which loading stage will give better performace, either ODBC, OraOCI or OraOCI Bulk Load.
currently i am usign Ora OCI bulk load, still consuming huge amount of time.
could you suggest me what type of load will do better performace.
Thx
My requirement loading huge amout of data into Orcle (10g) tables.
running on AIX 7.5 server edition.
which loading stage will give better performace, either ODBC, OraOCI or OraOCI Bulk Load.
currently i am usign Ora OCI bulk load, still consuming huge amount of time.
could you suggest me what type of load will do better performace.
Thx