How drop a database after connecting new one
i am tried drop database after connecting new database.I want to drop old database, there is message appeared"cannot drop database because it is currently in use".I connected new database, then why i cannot drop database?
Suthish NairPosted Apr 5, 2011, 11:25 PM
Sam HobbsPosted Apr 5, 2011, 5:03 PM
Suthish NairPosted Apr 5, 2011, 12:36 PM
You need to release or kill all user sessions and all threads before droping the database.
Soft CornerPosted Apr 2, 2011, 12:55 AM
Can you show your code here, might be you have open connection in code & if that so, close existing one and reopen your connection.