Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why Oracle Enforce Name Uniquness ???!!!
Serge Rielau wrote :
> hasta_l3_at_hotmail.com wrote:
> > 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.
> I suppose a simpl ekeyword:
> CREATE SYNONYM emp FOR TABLE employee
> would have done the job.
> But I agree that now it's too late.
> Legacy is a *b**** we all have to live with :-(
>
> > 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 ???
> Actually that one is not an issue I believe because
> both synonyms could only be resolved within the namespace
> "environment" of the objects the y refer to.
Well... drop synonym emp -- which one ? :-)
We would replace a very simple rule by a lot of complications, IMO. Received on Sun Nov 05 2006 - 17:51:56 CST