It there anyway to lock/block all connection to user during schema refresh..
options I have currently:
1. Bring listener down (but it will made full db unavailable which I don't want)
2. Lock user account... (will it also block other user who has got schema access rights? )
any other options?
Oh, do you want to stop connections from ONE user/schema ? Sorry, I misunderstood your request. Just lock the account, it will only affect new connections. Be careful though: some applications use multiple connections without you noticing.
P.S.: "enable restricted session" also affects only new connections.
Edited by: Marcus Rangel on Nov 26, 2012 1:38 PM