QUESTION POSED ON: 29 November 2006
I've created a view called 'CONTACT.' But later, I need to alter the CONTACT view to 'with read only.' I try to alter it with the ALTER command, but it doesn't work. Do you have any idea what's wrong? Thanks for your help in advance.
SQL> create view contact
2 as select contact, name, phone
3 from publisher;
View created.
SQL> alter view contact (contact, name, phone
2 as select contact, name, phone
3 from publisher
4 with read only;
alter view contact (contact, name, phone)
*
ERROR at line 1:
ORA-00922: missing or invalid option
|
