| Materialized view refesh fails with SDO [message #75374] |
Tue, 24 June 2003 02:20 |
novice SDO
Messages: 1
Registered: June 2003
|
Junior Member |
|
|
Hi,
I am on db 9.2.0.1.0 and created a materialized view that involves a select on SDO data.
The view creates successfully without any issues, although when the view tries to refresh, the operation is unsuccessful and no data is populated.
I then execute the "execute dbms_mview.refresh('view_name','c');" for a complete refresh and there is no problem, the view becomes populated.
I have many other materialized views in several schemas in the instance with no problems, the only difference is the presence of an sdo_relate in the query.
Has anyone else encountered the same or related issues involving materialized views involving spatial queries?
Any help would be appreciated!
cheers
:-)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
