Asynch CDC: Waiting For Dictionary Redo

Uli Bethke Oracle

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 does not match the first_scn when creating the change source on the downstream server. You need to supply the first_scn of the ...

Book Review: Inmon - DW 2.0. The Architecture for the next Generation of Data Warehousing

Uli Bethke DW Design

Get it from Get it from First of all, this book is not written with the DW novice in mind. Some of the chapters require a thorough understanding of DW theory and concepts. Generally I found the book useful and I got some ideas that I will apply in one of my next projects. The biggest weakness of ...

Run Procees Flow from Command Line or SQL+

Uli Bethke Oracle Warehouse Builder

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.

You need to call the sqlplus_exec_template.sql from sqlplus ...