Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can we use CREATE OR REPLACE materialized view ?

604114Oct 29 2008 — edited Oct 29 2008
Can we use CREATE OR REPLACE for materialized views. Create command is working fine. But when I use create or replace, its giving below error:
ORA-00922: missing or invalid option

Can you please help.

Thanks
Ravdeep
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2008
Added on Oct 29 2008
4 comments
18,468 views