Re: Non Oracle UML question
- From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
- To: andrew.clarke@xxxxxxxxxxxxx
- Date: Mon, 27 Feb 2006 18:29:39 +0200
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@xxxxxxxxxxxxx>:
> 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@xxxxxxxxxxxxx
> ________________________________
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Robertson Lee - lerobe
> Sent: 24 February 2006 09:59
> To: oracle-l@xxxxxxxxxxxxx
> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
