Droping a materialized view and keeping existing
Hi Folks,
I listed a following INVALID Objects.
SELECT OBJECT_NAME, STATUS, OWNER, OBJECT_TYPE FROM DBA_OBJECTS
WHERE STATUS = 'INVALID'
ORDER BY owner,OBJECT_TYPE
OBJECT_NAME STATUS OWNER OBJECT_TYPE
-------------------------------------------------------------------------------------------------------------------------------- ------- ------------------------------ -------------------
VWS_GIS_MUNICIPIO_C INVALID GEOFURNAS MATERIALIZED VIEW
So , I decided to drop this object using the folowing statement:
drop MATERIALIZED VIEW GEOFURNAS.VWS_GIS_MUNICIPIO_C ;
materialized view GEOFURNAS.VWS_GIS_MUNICIPIO_C dropped.
But when I listed the query again, the object keep listed on DBA_OBJETCS.
Has anyone an idea?
Thanks in advance,
André Teixeira