Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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_TSTReceived on Mon Dec 12 2005 - 09:37:39 CST