Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback Segment Won't Drop
Paul Cowan wrote:
> Any ideas? Is there a way to figure out what is causing the segement
> to think there's a transaction in progress, or see what the
> transaction is? Is there such a thing as a "ghost" transaction?
>
> Thanks
> Paul
Since you bounced the database, it's not something that got "stuck" in memory. This is a wild guess, but is RBS7 a public rollback segment that's still listed in your init.ora? Afraid this isn't much help. I looked in my backup/recovery books to see if they were any help in this particular scenario. Nope. Received on Mon Oct 21 2002 - 15:05:51 CDT