Home » Server Options » Spatial » Materialized view refesh fails with SDO
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
:-)
Previous Topic: very urgent - want to download pachset 9
Next Topic: SQLLoader problems with Spatial Data
Goto Forum:
  


Current Time: Thu Jul 02 15:09:22 CDT 2020