Database Administration (MOSC)

MOSC Banner

Table and Materialized View with same name in the same schema

edited Feb 10, 2012 2:08AM in Database Administration (MOSC) 11 comments
Hi all,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center