sqlldr -direct path loading [message #303961] |
Mon, 03 March 2008 07:55 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
venkat_sadineni
Messages: 3 Registered: March 2008 Location: hyderabad
|
Junior Member |
|
|
i am using sqlldr directpath loading
sqlldr uname/psq@db control=contro.ctl log=logfile.log direct=true
table constraints wil be left in index unusable state.
how can i achieve bulkloading (direct path)
|
|
|
|
|
|
Re: sqlldr -direct path loading [message #304123 is a reply to message #304066] |
Tue, 04 March 2008 03:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
venkat_sadineni
Messages: 3 Registered: March 2008 Location: hyderabad
|
Junior Member |
|
|
i am sorry i have not given clear infomation,
i am new to this fourum,
i want to load my database with direct path loadning,
please guide me the Direct path loading,
i don't want to disable my indexes ,
is there any auto disable constraints (before loading )and enable constraints after loading option are there?
how do i achieve bulkloading with directpath loading,
i want to call sqlldr programatically,
please help me out.
Thanks
Aruna Roy..............
hyd
|
|
|
Re: sqlldr -direct path loading [message #304138 is a reply to message #304123] |
Tue, 04 March 2008 04:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | i want to load my database with direct path loadning
|
You did it.
Quote: | i don't want to disable my indexes
|
From doc:
Quote: | SQL*Loader leaves indexes in an Index Unusable state when the data segment being loaded becomes more up-to-date than the index segments that index it. The following conditions cause a direct path load to leave an index or a partition of a partitioned index in an Index Unusable state:
* SQL*Loader runs out of space for the index and cannot update the index.
* The data is not in the order specified by the SORTED INDEXES clause.
* There is an instance failure, or the Oracle shadow process fails while building the index.
* There are duplicate keys in a unique index.
*Data savepoints are being used, and the load fails or is terminated by a keyboard interrupt after a data savepoint occurred.
|
Quote: | is there any auto disable constraints (before loading )and enable constraints after loading option are there?
|
From doc:
Quote: | During a direct path load, some integrity constraints are automatically disabled. Others are not.
The constraints that remain in force are:
* NOT NULL
* UNIQUE
* PRIMARY KEY (unique-constraints on not-null columns)
The following constraints are automatically disabled by default:
* CHECK constraints
* Referential constraints (FOREIGN KEY)
|
Quote: | how do i achieve bulkloading with directpath loading,
|
Once again you did it.
Quote: | i want to call sqlldr programatically,
|
Use external tables.
Regards
Michel
|
|
|