OraFAQ Forum: Server Utilities » sqlldr - change the load type from "bulk" to "normal" ?

Home » RDBMS Server » Server Utilities » sqlldr - change the load type from "bulk" to "normal" ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlldr - change the load type from "bulk" to "normal" ? [message #540663]

Wed, 25 January 2012 04:27

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

Report message to a moderator

Re: sqlldr - change the load type from "bulk" to "normal" ? [message #540665 is a reply to message #540663]

Wed, 25 January 2012 04:29

Michel Cadot
Messages: 66554
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

Report message to a moderator