I have made one script to data insert in 10 tables.
I will take half hour to run..
I wanto to locak those table initially , so nobody can insert recoreds on those tables during running script. and after completion of script i want to release locks.
Please give me idea for that
_____________________________________________________________________________________________________________
Paresh Prajapati
➡ +919924626601
http://paresh-sqldba.blogspot.com/[/url]
LinkedIn | Tweet Me | FaceBook | Brijj