Skip to Main Content
Forums

Java Database Connectivity (JDBC)

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!

CREATE OR REPLACE MATERIALIZED VIEW

Vsegu-OracleMar 16 2005 — edited Oct 15 2014
Hi,

I am getting the error mentioned below with REPLACE option in create statement for Materialized views. Could you please let me know whether REPLACE option works for materialized views.

CREATE OR REPLACE MATERIALIZED VIEW test_mv
REFRESH ON DEMAND AS
select * from emp

Error:

create or replace materialized view test_mv
*
ERROR at line 1:
ORA-00922: missing or invalid option

I tried in Oracle 9i and Oracle 8i

Thanks
Sowjanya

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2011
Added on Mar 16 2005
#database-connectivity-discussions
4 comments
10,350 views