Oracle 8.0.5 replication dictionary objects

From: Ken White <kwhite_at_tier.com.au>
Date: Wed, 28 Apr 1999 13:52:01 +1000
Message-ID: <7g60mj$th7$1@black.interact.net.au>

I have recently installed Oracle 8.0.5 and will be migrating our 7.3.3 databases. While testing this out, I have noticed that the table SYSTEM.DEF$_CALL from 7.3.3 has disappeared. We were using this table to build the SQL for a deferred transaction in error so that we could see why the transaction had been rejected and what the user was trying to do at the time.

I notice that there is a view DEFCALL (in both 7.3.3 and 8.0.5) which we could use (assuming that it returns the same information????) as we only use the columns deferred_tran_id, deferred_tran_db and procname from this table. The trouble is that one of the columns (deferred_tran_db) does not exist in the DEFCALL view in 8.0.5.

Does anyone know what view I must join to to get this information?

Any thoughts appreciated
Ken White Received on Tue Apr 27 1999 - 22:52:01 CDT