exclusive access to schema

I am currently writing an application for the purpose of archiving data from an existing schema. Our company has other applications which are working on the same schema. Since I want to read and delete from the schema, I need exclusive access, so no other application can modify -or even better- access the data in the schema. A simple LOCK TABLE won't work, because of the amount of data it is necessary to COMMIT frequently after a DELETE-statement to prevent the ROLLBACK-Segments from an overflow. COMMIT unlocks, so another application could sneak in and a corruption and inconsistency of data is possible. Does anybody know of a possibility I am not aware of?
Our system is ORACLE 7.3.

Thanks,
Holger Veit

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 03 1999 - 06:03:03 CDT