Skip to Main Content

Oracle Database Discussions

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!

drop materialized view

happy10319May 27 2010 — edited May 27 2010
Hi,
in 9i on Linux I should drop materialized view log emp in SCOTT schema. How to do that ?
I tried but
SQL> select object_name from dba_objects where object_type='MATERIALIZED VIEW' and owner='SCOTT';

OBJECT_NAME
--------------------------------------------------------------------------------
EMP_SNAPSHOT

SQL> drop materialized view log emp;
drop materialized view log emp
                           *
ERROR at line 1:
ORA-00969: missing ON keyword
Thank you.
This post has been answered by Lubiez Jean-Valentin on May 27 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2010
Added on May 27 2010
8 comments
1,498 views