Home » SQL & PL/SQL » SQL & PL/SQL » DDL statement on table on which materialized view is created
DDL statement on table on which materialized view is created [message #229927] Tue, 10 April 2007 05:57 Go to next message
kukreja
Messages: 33
Registered: February 2007
Member
I have created a table emp_tbl with two column emp_id,loc
and created a matrialized view on it such as

create materialized view emp_mv
refresh force on commit
with primary key
as
select * from emp_tbl;

now i have added one column in table emp_tbl and when I refresh matreialized view it is not getting refreshed.

and when I delete one column from table and try to refresh materialized it is giving me error.
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-00904: "E"."NAME": invalid identifier
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2257
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2463
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2432
ORA-06512: at line 1

Do DDL's changes not reflect on materialized view.
Plz clarify
Re: DDL statement on table on which materialized view is created [message #229930 is a reply to message #229927] Tue, 10 April 2007 06:00 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, they don't.
You have to recreate your MV.

Regards
Michel
Previous Topic: Basic query needed
Next Topic: Split string to rows
Goto Forum:
  


Current Time: Fri Dec 09 15:17:33 CST 2016

Total time taken to generate the page: 0.18966 seconds