Re: Creating tables & synonyms with Des2k.
From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 09 Apr 1999 17:06:53 +0200
Message-ID: <370E178C.8DDFFBB4_at_vnl.nl>
Date: Fri, 09 Apr 1999 17:06:53 +0200
Message-ID: <370E178C.8DDFFBB4_at_vnl.nl>
Bill Williams wrote:
<snip>
> Designer is not allowing me to create a synonym with the same name as
> the table.
Bill, sorry to say, but it's a bug (assuming you're using 2.1.1).
There's a bit of history here: building release 2, which can load
stuff directtly into the DB, a developer tested this, and got the
'Name is already in use by an exiting object' when testing the
table+synonym stuff. Figures (you cannot own a table, and create
a synonym for it, unless public). So, a check was built in to Des2k
to prevent this from happening (...).
There is a way to disable that, but need to dig into the triggers.
-- Frank van Bortel Technical Consultant Oracle V&L Informatica BV ------------------------------------------------- Work Home Postbus 545 Hunzestraat 4 7500 AM Enschede 7555 WB Hengelo (31)53.434.1500 (31)74.242.5046Received on Fri Apr 09 1999 - 17:06:53 CEST