AUTOMATE THE UNLOCK OBJECTS - NEED URGENT HELPAugust 15 2012 at 6:14 PM
No score for this post
from IP address 18.104.22.168
I am admin in Company,Here My issue is, There are some people in Support Team locking the objects every day(Outline, Calc scripts etc), After Office hours, some business users( They do have APP Manager Access) are trying open Outline or Run calc script, But It's already locked by support team. Then, Business people are really fluctuating.
To avoid this, I would like to automate the script which i want to unlock all the object those are only locked by Support Team NOT by users.
Could some one please help me how to do this. I appreciated if you could response asap.
- Re: AUTOMATE THE UNLOCK OBJECTS - NEED URGENT HELP - Jeff McAhren on Aug 15, 2012, 9:08 PM
- Try "Alter database unlock all objects;" - Jared on Aug 16, 2012, 12:27 PM