Quote:
Originally posted by eherber
In V7.x the tablespace is locked during the LOAD, in V8.1 only the table itself is locked.
But this might also not be desirable in a 24x7 OLTP system.
Best regards
Eric
--
IT-Consulting Herber
WWW: http://www.herber-consulting.de
Email: eric@herber-consulting.de
***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************
|
Thank you eric,
so I can not use Load because delete command is used in application and we can not lock the tablespace (in that time we have read write in so many tables in tablespace. How about if I use dectare cursor and use delete command with "with current cursor <corsur-name>?