How to access OWB public design views 11g?
HaakonSep 17 2009 — edited Oct 16 2009(Apologies if this had been debated earlier - I couldn't find any threads on the specifics though...)
On Oracle RDBMS 11G, Oracle Warehouse Builder 11.1.0.7.0
I need to query the design views like ALL_IV_PROCESS_TRANSITIONS etc in SQL*Plus.
- I log on as the runtime repository owner (OWBRTREP)
- I execute the OWBSYS.WB_WORKSPACE_MANAGEMENT.SET_WORKSPACE('OWBRTREP','OWBRTREP');
- I try:
SELECT * FROM OWBSYS.ALL_IV_PROCESS_TRANSITIONS;
no rows returned....
(I've granted OWBRTREP SELECT-rights on the OWBSYS-view previously)
As a test, I've tried querying ALL_IV_SCHEMAS both before and after doing the SET_WORKSPACE, and can verify that it doesn't return data before - and does return 4 rows after. So the SET_WORKSPACE works and has effect on the session.
By going through the view definitions of ALL_IV_PROCESS_TRANSITIONS and the underlying views, I end up finding lots of data in the base table.
What are we doing wrong here?
(I know the sql user needs to be registered at a workspace user in OWB, and this is the repository owner I'm querying from).
Any hint that may shed some light on this is highly appreciated!
Regards,
Haakon