Error in replacing Materialized View
I have got a materialized view which I want to change its definition. The problem is that some objects refer to the materializaed view and the view cannot be dropped easily.
I tried the following command in order to replace the view:
CREATE or replace MATERIALIZED VIEW schema.table ("field")
ORGANIZATION HEAP
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE(INITIAL 64K
BUFFER_POOL DEFAULT)
TABLESPACE ARSYSTEM
LOGGING
NOPARALLEL
NOCACHE
BUILD IMMEDIATE
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 64K BUFFER_POOL DEFAULT) TABLESPACE ARSYSTEM
REFRESH FORCE
ON DEMAND
AS select "field" from schema.table
/
However, it states the following error:
Error: ora-00922