Re: ORA01453 WITH REPLICATION

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Sun, 27 Jan 2002 07:26:48 -0800
Message-ID: <F001.003FC63C.20020127071019@fatcity.com>

What are the versions of the db's involved?

Are you doing updatable snapshots or multi-master replication?

My guess is that the replication trigger that is populating the deferred transaction queue is firing before the RBS is set as part of the application or another trigger.

If this is an OLTP application why does it bother assigning RBS's to transactions? If this is happening during a batch job or bulk update, you'd be better off implementing procedural replication.

HTH,

• Anita
  • אדר_יחיאל <adary_at_mehish.co.il> wrote:
    > Hello All
    >
    > As a first step I am applying to all you
    > knowledgeable persons on the list.
    > (Metalink and itar will follow)
    >
    > I have an application that worked fine until I
    > activated synchronous
    > replication on that schema.
    > After the replication was build the user activated a
    > program that access
    > Oracle via OCI
    > and got error ora1453 - SET TRANSACTION must be
    > first statement of
    > transaction
    > I dropped the replication and started again the same
    > program. No problems.
    >
    > H E L P !!!!!!!
    >
    > Yechiel Adar, Mehish Computer Services
    > adary_at_mehish.co.il
    

    ---

Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sun Jan 27 2002 - 09:26:48 CST