Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to lock entire schema?

426395Oct 20 2004 — edited Oct 21 2004

Hello,

Is it possible to lock all objects in a schema in exclusive mode, in one go?

We have one OCI client and several JDBC clients all connecting as the same user to the same schema named 'user1'. The requirement that we want to implement now is that once the OCI client has made its connection to the database schema and started doing some processing, JDBC clients connecting after that should not be able to perform any actions at all on that schema. I think that one way to do this might be for the OCI client to lock the entire schema in exclusive mode (if that is possible.)

Any other suggestions?

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2004

Added on Oct 20 2004

#general-database-discussions

11 comments

648 views