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.