Hi Aage

> > Sweep has no effect so assume it's not rollback.
>
> Did you try it in "single user mode" ?
>

No - I'll do it tonight when they're all off.

>
> > Backup+restore does remove it but its not a permanent solution
>
> Right. If the problem is in an app you'll need to fix it - the only
> permanent solution.
> If it was just a rollback, there's not a lot to fix in the app :-) But a
> 'single user mode' sweep might fix the current gap - and it wouldn't bite
> you until next time ...
>

I suppose it may be that forcibly disconnecting any users may release the
stuck transaction. There's no gap between OIT and OAT so according to the
articles it is a stuck transaction - I'll just have to find whats causing it
:-(

Regards
Paul