Table and Materialized View with same name in the same schema
According to the documentation, tables and materialized view should share the same namespace and so no two such objects with the same name should exist in the same schema.
But we have encountered such a case, the two differ in the table dba_objects in a single attribute and that is the namespace: it is 1 for the table and 19 for the materialized view.
select substr(object_name,1,20) NAME,owner,namespace from dba_objects
where object_name='CX_D_BROWSE_EXTRP_ADD';
NAME OWNER NAMESPACE
-------------------- ------------------------------ ----------
CX_D_BROWSE_EXTRP_AD TOMS_COMMON 1
CX_D_BROWSE_EXTRP_AD TOMS_COMMON 19