This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Oracle acts out. Can't drop a user. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle acts out. Can Watch "Oracle acts out. Can New topic
Author

Oracle acts out. Can't drop a user.

John Landon
Ranch Hand

Joined: Sep 25, 2008
Posts: 227
Hi,
Here is what I am trying to do. I just want to drop the damn schema.


Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
The ORA-01940 can be resolved by bouncing the source and replicated instance.

But FIRST, be sure the user is not connected to the current instance.



Check that the user is not associated with any active jobs:


Determine that the user is not associated with any stream replication queues:






After releasing a user from propagation replication, you can drop the user.
You will need to then redefine the replication mechanism.
[ November 17, 2008: Message edited by: Paul Campbell ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle acts out. Can't drop a user.
 
Similar Threads
JDBC Max number of cursors exceeded issue
need to drop number of user from database
ORA-00353: log corruption near block 75760 change 5605346 time 01/07/2012 11:41:31
getting error while droping the user in oracle.
Not able to drop user Oracle10.2.0.3 Ent Ed.