 sqlldr -direct path loading [message #303961] |
Mon, 03 March 2008 07:55  |
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  |
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 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
