Re: Creating tables & synonyms with Des2k.

[Quoted] [Quoted] 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.

[Quoted] [Quoted] 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?

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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 15 1999 - 08:05:16 CEST