This discussion is archived
6 Replies Latest reply: Nov 10, 2012 6:58 AM by Richard Harrison . RSS

sqlldr- ORA-00060: deadlock detected while waiting for resource

user9256814 Newbie
Currently Being Moderated
Hi Team,

My database version is 11.1.0.7.0. I am loading the data using sqlldr. I am getting the error ORA-00060: deadlock detected while waiting for resource. once dead lock detected ,whether data will be rejected after commit point reached(Rows=100000). FYI information only sqllder is running on the database,it is getting completed withing 5-10min. please help me whether any other lock happening on this due to sqllder.

sqlldr userid=orcl/orcle control=".$controlfile." log=".$logfile.".log data=".$datafile." bad=".$badfile." discard=".$discardfile." Bindsize=19000000 Rows=100000 Readsize=20000000 Errors=1000000";


Thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points