Re: Why Oracle Enforce Name Uniquness ???!!!

Serge Rielau wrote :

> Food for thought.
> Serge

Serge, to perhaps give some food to your previous question :

> It certainly is an interesting question why
> Oracle lumps routines and packages into the
> same name space with tables.

consider that Oracle allows one to create a synonym for a package. Now, if package and table names were in different namespaces, then one would have funny ambiguities :

  create table employee...
  create package employee...
  create synonym emp for employee -- which one ?

Of course, this syntactic ambiguity could be somehow lifted. But then, things would become *really* funny. Indeed, one could very logically try to write :

  create synonym emp for table employee
  create synonym emp for package employee -- ??? two synonyms with same name ???

and therein lie dragons :-) Received on Sun Nov 05 2006 - 15:19:38 CST