Home » RDBMS Server » Server Utilities » SQL loader to import
SQL loader to import [message #218964] Mon, 12 February 2007 04:58 Go to next message
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


Re: SQL loader to import [message #218967 is a reply to message #218964] Mon, 12 February 2007 05:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: SQL loader to import [message #218997 is a reply to message #218964] Mon, 12 February 2007 08:00 Go to previous message
vin_odks
Messages: 153
Registered: July 2006
Location: -
Senior Member
Thank you mahesh.. I shall keep the post updated about the results
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:
  


Current Time: Sun Dec 04 12:37:24 CST 2016

Total time taken to generate the page: 0.07931 seconds