Home » RDBMS Server » Server Utilities » sqlldr - change the load type from "bulk" to "normal" ?
sqlldr - change the load type from "bulk" to "normal" ? [message #540663] Wed, 25 January 2012 04:27 Go to next message
nago
Messages: 10
Registered: January 2012
Junior Member
Hi,
once again,me nago Sad.

in my previous post, i have got great suggestions from you.
i have another issue that i wanted to share with you.

sqlldr works fine. but, i have primary keys defined in the table.
So the SQL loader throws error that

SQL*Loader-951: Error calling once/load initialization
ORA-26002: Table WD has index defined upon it.


when i googled for solution, it says we need change the load type from BULK to Normal.

how should i change this load type to "normal" in sqlldr ?
i think sqlldr made for bulk load purpose only. any suggestions ?


Thank you
nago
Re: sqlldr - change the load type from "bulk" to "normal" ? [message #540665 is a reply to message #540663] Wed, 25 January 2012 04:29 Go to previous messageGo to next message
Michel Cadot
Messages: 59285
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-26002: Table %s has index defined upon it.\n
 *Cause:   Parallel load was specified into a table which has index
           defined upon it.
 *Action:  Drop index(es) defined upon table, or don't use parallel load,
           or use SKIP_INDEX_MAINTENANCE option.

Regards
Michel
Re: sqlldr - change the load type from "bulk" to "normal" ? [message #540666 is a reply to message #540665] Wed, 25 January 2012 04:39 Go to previous messageGo to next message
nago
Messages: 10
Registered: January 2012
Junior Member
HI,
It works fine when i make DIRECT=FALSE in the control file. before it was TRUE status. Smile
however, do you know what is this DIRECT option exactly does ?

thank you
nago

[Updated on: Wed, 25 January 2012 04:39]

Report message to a moderator

Re: sqlldr - change the load type from "bulk" to "normal" ? [message #540667 is a reply to message #540666] Wed, 25 January 2012 04:44 Go to previous message
cookiemonster
Messages: 10988
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have you looked it up in the documentation?
Previous Topic: sqlldr issue with many tables
Next Topic: data import from production to test
Goto Forum:
  


Current Time: Wed Oct 01 06:09:05 CDT 2014

Total time taken to generate the page: 0.11119 seconds