Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

URGENT - How Do I get RAB info in SQL

401898Dec 11 2003 — edited Dec 11 2003

Hi, I need some urgent help on getting the log information for OWB mapping jobs that is viewed in the Runtime Audit Browser from SQLplus. I dont have the abiltiy to use the RAB over RAS at 2am in the wee hours, and I really need to know how to get the information out of the runtime to diagnose the faults.

Can someone identify the tables I need to use and how I can get the information out. Of course a script that can be run, that takes the mapping name, type and date and produces the exe style report would be the best...

This is proving to be a big issue for me now that we are supporting OWB marts, 24*7

Many thanks in advance guys...

Richard.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2004

Added on Dec 11 2003

#data-warehousing, #warehouse-builder

1 comment

258 views