Re: In doubt distributed transactions

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 12 Mar 1999 08:38:10 -0000
Message-ID: <921228119.4895.0.nnrp-06.9e984b29@news.demon.co.uk>

Is it possible that the database has been upgraded from one version of Oracle to
another and some of the catalog SQL scripts have not been run ?

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

yewpc_at_my-dejanews.com wrote in message <7cahop$o0g$1_at_nnrp1.dejanews.com>...
>Hi,
>
>I try to :
> execute dbms_transaction.purge_lost_db_entry(global_txn_id);
>
>if i execute it using sys user I get the following error :
>ERROR at line 1:
>ORA-06510: PL/SQL: unhandled user-defined exception
>ORA-06512: at "SYS.DBMS_TRANSACTION", line 94
>ORA-06512: at line 1
>
>
>if i execute it using system user i get different error :
>ERROR at line 1:
>ORA-00942: table or view does not exist
>ORA-06512: at "SYS.DBMS_TRANSACTION", line 86
>ORA-06512: at line 1
>
Received on Fri Mar 12 1999 - 02:38:10 CST