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:[EMAIL PROTECTED] >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
