Re: Allow 2 processes access to same table

> Can you post the sql and table definitions etc?

There are 5 of these type of queries and each one takes approx 1-3 hrs to run. This box is running more than one instance and the instance that these scripts relate to has a number of users on it.

example sql

select count(*) "XXXX"
from XXXX;

delete from XXXX
where id in (select id

	     from XXXXXXXX <---- This is a different tablename
      where DATELASTALTERED < 'DD-MMM-YYYY');

select count(*) "XXXX"
from XXXX;

desc XXXX

Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------
----
 ID                                        NOT NULL NUMBER(10)
 XXXX                               NOT NULL NUMBER(10)
 XXXXDATA                                         BLOB

thanks for any input

Tom Received on Wed Oct 22 2003 - 14:00:46 CDT