Re: Insert into Materialized View

It looks like they are in the same schema:

SQL> select owner, object_type, object_name from dba_objects where object_name = 'SPECIAL_TST';

OWNER                          OBJECT_TYPE        OBJECT_NAME
------------------------------ ------------------ --------------------
PUBLIC                         SYNONYM            SPECIAL_TST
MIRS_LOOKUP                    MATERIALIZED VIEW  SPECIAL_TST
MIRS_LOOKUP                    TABLE              SPECIAL_TST