i have a problem with droping the user.....
it not allowing me to drop the user,saying that the user is currently connected......but there is no sessions opened for that user....??
I assume you have check v$session looking for the offending user.
Is the offending user associated with any active jobs?
Do you have replication in place in your environment? does the user owns replication?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
There is not active jobs for that user...in the v$session.
No replication, and i checked in v$dblink for any transaction is going on or not...no transaction is there..
Sorry man its my mistake.......
i have some session in the node 2...
If in RAC env then its better to check in GV$ views.
Yes u are right , that the thing i first missed
Originally Posted by paragp1981
Click Here to Expand Forum to Full Width