Re: Creating tables & synonyms with Des2k.

chanacampos_at_my-dejanews.com wrote:
>
> No - Oracle can't accept a blank or an underscore (among other things) as the
> first character in an object name. I believe your problem may be that if you
> are trying to create a synonym with the exact name as your table - Oracle
> thinks you are trying to create a new object with the same name - thus
> causing a uniqueness conflict. Also, you must own the object before you will
> be allowed to create a synonym for it - or have rights to do so.

There is a "Scope" property in Des2k 2.1.2. Just set it to PUBLIC and you'll can add a synonym with the same name as the table name :)

>
> But - I'm a little curious - why would you want to use the exact name of the
> table as your synonym...is this a location transparency issue?

It is because I want to use PUBLIC synonyms to all objects in my application scheme. I don't like to use schema prefixes in my development... If you use synonyms you can change references without modifying your code :)

Thank you for your reply.

With best wishes,
Valeri

>
> Best wishes,
>
> Chana
>
> > Sorry, it's not working... ("... is not a valid ORACLE object name")
> >
> > Vladimir A. Zaikin wrote:
> > >
> > > Hi, Bill
> > >
> > > Try to insert the blank before the name of synonym. It's name
> > > will be not so unique with table name.
> > >
> > > Vladimir Zaikin
> > >
> > > > Designer is not allowing me to create a synonym with the same name as
> > > > the table.

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru