Re: designer 6.0 question
- From: "Joseph S. Testa" <jtesta@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 17 Mar 2004 16:58:12 -0500
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
thanks to all of you who proved i was not insane(at least on the
designer 6.0 question).
I'll quit looking for something that does not exist.
joe
John Flack wrote:
|The relationship never shows up as an attribute, unless you add the
attribute yourself. It only shows up as a column when you run the
Database Design Transformer (DDT) and convert your entities to tables
and attributes to columns. There are some DDT options to control how
that happens. DDT also creates surrogate PK columns and the sequences
to generate them whenever you don't designate an attribute or set of
attributes as the PK.
|
|This part of Designer hasn't changed very much from 6 to 6i and 9i.
|
|-----Original Message-----
|From: jtesta@xxxxxxxxxx [mailto:jtesta@xxxxxxxxxx]
|Sent: Wednesday, March 17, 2004 3:50 PM
|To: oracle-l@xxxxxxxxxxxxx
|Subject: designer 6.0 question
|
|
|Yea, I know its old but its what i'm currently having to use.
|
|that being said, anyone on the list remember using designer 6.0. I've
used
|ERWIN off/on for years and remember Erwin doing the following:
|
|when creating a relationship between 2 entities and the uniq ID is
already
|defined, the PK from the parent would migrate as an attribute to the
child
|and show up in the child entity as an attribute. I can't seem to get
|designer to do that.
|
|although if i get all the way thru and generate DDL, the column is in the
|create table statement for the child.
|
|Anyone know what the heck I'm talking about?
|
|thanks, joe
|----------------------------------------------------------------
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|----------------------------------------------------------------
|To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
|put 'unsubscribe' in the subject line.
|--
|Archives are at //www.freelists.org/archives/oracle-l/
|FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
|-----------------------------------------------------------------
|
- --
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the "CACHE"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFAWMnzR8fSap71V7YRAhMYAJ9K79Q4woXqAETLWi989F2TbrdZNACfddNp
KUe9+p8IndN8/jIImulw9t0=
=cOGu
-----END PGP SIGNATURE-----
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
