Hi Oracle folks ,
Here is a fundamental question about Oracle objects.
Can a table and a materialized view have the same name in one schema
in an oracle db?
While searching for an object_type I got the following
SQL>select owner,object_name,object_type,status from dba_objects where object_name='ACCOUNT_D' and owner='CR_STAGE';

Result:
-------
Owner Object_Name Object_Type Status
----------- -------------- ------------------- -------
CR_STAGE ACCOUNT_D TABLE VALID
CR_STAGE ACCOUNT_D MATERIALIZED VIEW VALID

As per my fundamental for both table and materialized view namespace is same , the schema . I dont some where I am going wrong.
Please have a look and advise.
Thanks
Armaan