| sql-loader an indexes [message #73329] |
Fri, 26 March 2004 04:29  |
Nauj
Messages: 33
Registered: February 2004
|
Member |
|
|
Hi
I'm working with sql-loader in Oracle8. I'm loading a table with one index, ¿can i have any problem with that index?, problems of unusable index or something similar
|
|
|
|
| Re: sql-loader an indexes [message #73335 is a reply to message #73329] |
Mon, 29 March 2004 01:40  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
If you use the "skip_index_maintenance" option, you may very well end up with unusable indexes (Default FALSE).
Also, according to chapter 8 of the Oracle8 Utilities Guide:
"The following conditions cause the direct path option to leave an index or a partition of a partitioned index in 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 save points are being used, and the load fails or is terminated via a keyboard interrupt after a data save point occurred."
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
