Asynch CDC: Waiting For Dictionary Redo

Uli Bethke October 8, 2008

I have come across (so far) four scenarios that show capture process “hanging” as WAITING FOR DICTIONARY REDO. 1. Wrong first_scn supplied for create_autolog_change_source: The first_scn when building the the data dictionary in the redo log via dbms_capture_adm.build does not match the first_scn when creating the change source on the downstream server. You need to ...

Read More

Run Procees Flow from Command Line or SQL+

Uli Bethke July 25, 2008

You can run a process flow from the command line. This is useful if you want to call a process flow from another application, e.g. if you want to use a 3rd party scheduler like AT or Cron etc. or if you want to script the execution of your process flows. sqlplus user/pwd@connect_identifier C:oracleproducts10.2.0owb_1owbrtpsqlsqlplus_exec_template.sql <rep_owner> ...

Read More

Automate OWB Metadata export with OMB+

Uli Bethke July 21, 2008

I regularly make exports of Warehouse Builder Metadata to files. I do this at least once a day. When there are a lot of changes to OWB objects I make the export multiple times a day. I prefer this over snapshots as these exports to file do not fill up the OWB repository. Regular exports ...

Read More
1 44 45 46