Database DataWarehousing (MOSC)

MOSC Banner

Droping a materialized view and keeping existing

edited Jul 1, 2014 10:05AM in Database DataWarehousing (MOSC) 5 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center