Re: exclusive access to schema

Hi

You could put the database in RESTRICTED mode. Then only users that have the DBA role or RESTRICTED SESSION privilege can access the database.

Hope this helps

Alistair Thomson

In article <7o6i94$954$1_at_nnrp1.deja.com>,   gerveit_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 04 1999 - 10:59:15 CDT