OraFAQ Forum: Server Utilities » SQL loader to import

Home » RDBMS Server » Server Utilities » SQL loader to import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL loader to import [message #218964]

Mon, 12 February 2007 04:58

vin_odks
Messages: 153
Registered: July 2006
Location: -

Senior Member

Hi,

We would like to import 12 million records into oracle thru SQL loader .

Please advice on

1) Optimum Parameters in SQL* loader to be used
2) Optimum Table creation parameter's like pctfree,pctused
3) Optimum Indexes.
4) Tuning and sizing the tablespace.
5) Any other suggestions are welcome ... Smile

Regards
Vinod

Report message to a moderator

Re: SQL loader to import [message #218967 is a reply to message #218964]

Mon, 12 February 2007 05:03

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQLLDR Direct Load
Table creation parameters depend on your application/need.
You do not want any indexes at all during the load. Presence of indexes are good during select , but hinder the performance of insert operations.
LMT with uniform extent size.

Report message to a moderator

Re: SQL loader to import [message #218997 is a reply to message #218964]

Mon, 12 February 2007 08:00

vin_odks
Messages: 153
Registered: July 2006
Location: -

Senior Member

Thank you mahesh.. I shall keep the post updated about the results

Report message to a moderator

Previous Topic:	how to use sqlldr direct path to load chr(0)
Next Topic:	Import error "ORA-01925: maximum of 148 enabled roles exceeded"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 21:08:39 CST 2024