Hi!

ALTER TABLE LOCATIONS
ADD BO_ROW VARCHAR(10)

... then commit and then ...

alter table ITEMS
add constraint FK_ITEM_LOCATION
foreign key (LOCATION_ID)
references LOCATIONS(ID)
on delete SET NULL
on update CASCADE

Im not sure if first statement has to do with my problem at all but
second statement generates "LOCATIONS is in use" error, but only
sometimes. As far as I know there was only one connection to the
database at this moment.

Should I assume that if this error occured then there had to be some
unnoticed hanging connections left to the database or are there other
possibilities?


thanks,

Aivar