This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Oracle acts out. Can't drop a user.  RSS feed

 
John Landon
Ranch Hand
Posts: 239
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Here is what I am trying to do. I just want to drop the damn schema.


 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!