I have a oracle table where i am loading with direct =true and parallel
=true , but i have global indexes and integrity constraints on the same
table. Now when two unix processes tries to insert/delete/ update the
table first processes disables the constraitns and indexes and do database
operation then again enables. But in mean time if the second process tries
to access the same table it gives error. Can anyone suggest the
solution???

thanks,
Nikunjkumar Umeshchandra Purohit
ASE
Tata Consultancy Services Limited
801/1001, Sarkar II,
Off Ashram Road,
Ellis Bridge,
Ahmedabad - 380 006,Gujarat
India
Mailto: nikunjkumar.[Email address protected]
Website: http://www.tcs.com
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you



Oracle LazyDBA home page