Loading into Oracle Tables

reddysrc · Post by **reddysrc** » 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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Sep 24, 2009 9:33 am

Ask your DBA to monitor the load performance.

Try Parallel, Direct Path options with your load.

Are there any constraints in the table ?