Re: Non Oracle UML question

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Mon, 27 Feb 2006 18:29:39 +0200
Message-ID: <6e49b6d00602270829g147e99cck@mail.gmail.com>

Khe downloaded it and found an interesting bug immediately ;) I have many similar schemas with the same structure for testing purposes and they all can see each other because of DBA role.

So as a result for a table I got following FK constraint generation statement

ALTER TABLE CMIS_DB2.IRA_ADOPCIJAS
  ADD CONSTRAINT FK_RADP_KAIM FOREIGN KEY (RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID,RADP_KAIM_ID)   REFERENCES CMIS_DB4.KLS_AKT_IEMESLI(KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID,KAIM_ID) /

But I only have 4 schemas (with identical constraint name) so the tool multiplies not only with 4 ;)))

Gints

2006/2/27, Clarke, Andrew <andrew.clarke_at_logicacmg.com>:
> It's not a UML tool but Schemester is free and a heck of a lot better at
> modelling databases than Visio: http://www.schemester.co.uk/
>
> If you do have Vision already and you want to add UML capability Pavel Hruby
> has free ones on his web site:
> http://www.phruby.com/index.html
>
> Cheers, APC
>
>
>
> A P Clarke
> Technical Consultant
> LogicaCMG UK Public Sector Division
> Stephenson House
> 75 Hampstead Road
> London
> UK
> NW1 2PL
> Direct Tel: +44 (0)207 446 4006
> Fax: +44 (0)207 446 1352
> Email: andrew.clarke_at_logicacmg.com
> ________________________________
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Robertson Lee - lerobe
> Sent: 24 February 2006 09:59
> To: oracle-l_at_freelists.org
> Subject: Non Oracle UML question
>
>
> Hi,
>
> Sorry for the non Oracle specific question but I was wondering what you guys
> out there were using to build models (LDMs, PDMs etc.) ?
>
> I would prefer cheap or free tools if possible but any recommendations would
> be great.
>
> TIA
>
> Lee
> ***************************************************************************
The
> information contained in this communication is confidential, is
intended
> only for the use of the recipient named above, and may be
> legally

privileged.

If the reader of this message is not the intended
> recipient, you are

hereby notified that any dissemination, distribution or
> copying of this

communication is strictly prohibited.

If you have received
> this communication in error, please resend this
communication to the sender
> and delete the original message or any copy
of it from your computer
> system.

Thank
> You.

---

>
>
>
>
> This e-mail and any attachment is for authorised use by the intended
> recipient(s) only. It may contain proprietary material, confidential
> information and/or be subject to legal privilege. It should not be copied,
> disclosed to, retained or used by, any other party. If you are not an
> intended recipient then please promptly delete this e-mail and any
> attachment and all copies and inform the sender. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 27 2006 - 10:29:39 CST