| Oracle MVIEW Refresh Error for Discoverer [message #162685] |
Mon, 13 March 2006 01:15 |
BexOne
Messages: 10
Registered: August 2005
|
Junior Member |
|
|
Hi,
I have materialized view to summarized data and used by discoverer.
Scenario.....
Store Dim, Business Dim, Time Dim are views on master tables created as follows:
Create mview .....
cache
loggin
refresh fast on commit
with rowid
as select .... from master table.
MVIEW LOGS have already been created on master tables before mviews were created.
BCFACT is complex view with unions(all), joins, sum created as
follows:
create mview ......
cache
loggin
refresh force on demand
with rowid
as select ....... from table a,b,c,....union ......
Problem Description
Condition = mview data must refreshed when forms completes processing .
I have a procedure to refresh the mviews, when i refresh using procedure is ok works fine
When i plug the procedure in forms or database pkg called by forms i get the following error attached in word file:--
Pls. identify what are the different ways i can refresh my mviews to achieve the desired result after forms completes processing and how can i solve the problem above.
Regards,
BexOne.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
