RE: Verifying success of dbms_repcat.execute_ddl

Paul,

How about an ON DDL system trigger on the source (and possibly target) databases? This trigger can log any and every detail of the who/what/when whenever *any* DDL is performed by whoever...

Let me know if you need more details.
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

>-----Original Message-----
>From: Paul Baumgartel [mailto:treegarden_at_yahoo.com]
>Sent: Tuesday, December 02, 2003 4:29 PM
>To: Multiple recipients of list ORACLE-L
>Subject: Verifying success of dbms_repcat.execute_ddl
>
>
>I'm trying to determine when execution of DDL via
>DBMS_REPCAT.EXECUTE_DDL completes successfully on all master sites.
>I'm not sure how the DDL is propagated, but it doesn't appear to be via
>the replication administrator's scheduled jobs: I've removed the
>dbms_defer_sys.push job (via dbms_defer_sys.unschedule_push), and
>broken the dbms_repcat.do_deferred_repcat_admin job, then run
>dbms_repcat.execute_ddl. The results show up on the other master
>database within a couple of seconds.
>
>Anyway: If there is an error produced by the EXECUTE_DDL call, Oracle
>returns an error message immediately, and the error is also logged in
>dba_repcatlog (this led me to believe that execute_ddl calls were
>handled by dbms_repcat.do_deferred_repcat_admin, but that doesn't
>appear to be the case), so error detection is easy. What I need,
>though, is to be able to tell _when_ the DDL has been run on each
>master database (I am running a batch job that disables all FKs, then
>runs an import; the first attempt produced failures because the row
>insertions caused by the import arrived at the other master DB _before_
>the FK disablement).
>
>Any help appreciated. TIA.
>
>
>
>
>=====
>Paul Baumgartel
>Transcentive, Inc.
>www.transcentive.com
>
>__________________________________
>Do you Yahoo!?
>Free Pop-Up Blocker - Get it now
>http://companion.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Paul Baumgartel
> INET: treegarden_at_yahoo.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).