of list ORACLE-L
Subject: RE: ERD generation tool - Active SCM
Hey, how do you give that truncate only privilege
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message-
From: Keith Peterson [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 5:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERD generation tool
Of Kimberly Smith
[EMAIL PROTECTED]
Sent: Monday, May 06, 2002 10:28 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERD generation tool - Active SCM
Hey, how do you give that truncate only privilege
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET
ORACLE-L
Subject: RE: ERD generation tool - Active
Comparisons
Am I speaking to the wind
For Compares, why would you compare the MODEL
with
the
DATABASE...like going from US to London via
Tokyo...
... and you get to pay more, like... you pay not
for
distance
Yechiel,
here is additional information:
white paper:
http://www.iraje.com/docs/ActiveSecureDesigner.htm
WEBCAMS (4-6 mins) and screenshots:
ActiveChangeManager:
http://www.iraje.com/ActiveChangeManager_viewlet.html
http://www.iraje.com/acommanbig.htm
ActiveCompare:
: Wednesday, May 01, 2002 5:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERD generation tool - Active
Comparisons
Am I speaking to the wind
For Compares, why would you compare the MODEL
with
the
DATABASE...like going from US to London via
Tokyo
Yechiel,
How did you give a responsible person the ability to truncate a
table without granting delete any table. Very dangerious. There was a
long dicsussion on the list a while ago that displayed the dangers of
such a grant. I think it was followed up with an update your resume
statement.
Ron
Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message-
From: Keith Peterson [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 5:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERD generation tool - Active
, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message-
From: Keith Peterson [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 5:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERD generation tool - Active
Comparisons
PROTECTED]]
Sent: Sunday, May 05, 2002 7:48 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: ERD generation tool - Active SCM
Well , just to keep things jumping.
Last week I deviated from our rule and gave a responsible user
that needed truncate on tables the password
Message-
From: Keith Peterson [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 5:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERD generation tool - Active
Comparisons
Am I speaking to the wind
For Compares, why would you compare the MODEL
of list ORACLE-L
Subject: RE: ERD generation tool - Active
Comparisons
Am I speaking to the wind
For Compares, why would you compare the MODEL with
the
DATABASE...like going from US to London via
Tokyo...
... and you get to pay more, like... you pay not
for
distance
Why? For consistnecy. I am in charge of making ALL changes to the data model, then
rolling out those changes to the db. Our developers RELY on me and my tools for a
database that reflects the model that we developed (Without Error).
Therefore, everything we do here STARTS with the model
can move them, soemtimes I can't.
Hannah
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Koivu, Lisa
[EMAIL PROTECTED]
Sent: Wednesday, May 01, 2002 6:32 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERD generation tool
I have seen
Moving the columns should not be a problem for anyone, heck you should
be able to alphabetize them and everything be okay. If you take the
output and use it to create tables that should not cause a problem
except for the developer that codes for columns to appear in a specific
order.
Ron
ROR
:
Sent by: rootSubject: RE: ERD generation tool
Hello Ron
shameless plug
I was just looking at Joe new oracle 9i features at
http://www.oracle-dba.com
end shameless plug
I saw that log miner gives you something like:
update SCOTT.TEST_LOG set C2 = '10'
What happens if you extract this info and erd tool moved a column?
Inquiring minds wants
ORACLE-L
Subject: RE: ERD generation tool - Active
Comparisons
Am I speaking to the wind
For Compares, why would you compare the MODEL with
the
DATABASE...like going from US to London via Tokyo...
... and you get to pay more, like... you pay not for
distance, but for time in the air
cgrabowy[EMAIL PROTECTED]
@fcg.comcc:
Sent by: rootSubject: RE: ERD generation
tool
05/01/2002
06:56 PM
Please
it.
Grabowy,
Chris To: Multiple recipients of list
ORACLE-L
cgrabowy[EMAIL PROTECTED]
@fcg.comcc:
Sent by: rootSubject: RE: ERD generation
tool
of list ORACLE-L
Subject: RE: ERD generation tool - Active SCM
Lisa,
There is only so much you can control via a model,
since it remains a process away from the DB, and
cannot be enforced via privileges, etc. So, we are
always in the hands of Dom Phoc (and their siblings),
who can do
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Ron wrote:
Did you use the changed ERD to create a table and then use old archives to
mine the data changes?
NO.
I did not started to work with log miner yet.
I just saw the article that Joe published and thought about this point.
I have enough experience to know that you can not teach old
You don't say.
-Original Message-
Sent: Thursday, May 02, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
]]
Sent: Wednesday, May 01, 2002 5:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERD generation tool - Active
Comparisons
Am I speaking to the wind
For Compares, why would you compare the MODEL with
the
DATABASE...like going from US to London via Tokyo
. Lauderdale, FL, USA 33063
-Original Message-
From: Yechiel Adar [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ERD generation tool - Active SCM
Well Keith
Our solution to the Doom Phoc (and their siblings
Yechiel,
In the instance that you refer to it could present a problem if you
use the changed table description to build a different instance and
then used the mined info to update the table in the new instance. This
would be a case where the source and target databases are not the same
and then
To: Multiple recipients of list
ORACLE-L
cgrabowy[EMAIL PROTECTED]
@fcg.comcc:
Sent by: rootSubject: RE: ERD generation
tool
05/01/2002
06:56
[EMAIL PROTECTED]
Subject :
RE: ERD generation tool
Date :
Tue, 30 Apr 2002 06:03:36 -0800
ERWin www.ca.com
ERStudio www.embarcadero.com
Active Designer http://www.iraje.com/ad_fsmain.htm
HTH
Mark
-Original Message-
Sean
Sent: 30 April 2002 13:24
To: Multiple recipients of list ORACLE-L
I've used the release of Embarcadero's ERSudio that was new about two months
ago. It is OK if you really just want to do modeling and have relatively
low expectations for some of hte more advanced capabilities of such tools.
If does a decent job with diagrams and its rather simple standard
ERWin's not much better. Has some better modeling capability as you might guess, but
has some VERY annoying quirks too. You also need to drill down endlessly when doing a
compare and I have seen it see two exact tables (even case being the same) and see
them as different. The DO have a
Am I speaking to the wind
For Compares, why would you compare the MODEL with the
DATABASE...like going from US to London via Tokyo...
... and you get to pay more, like... you pay not for
distance, but for time in the air... If a tool takes
longer to do something, makes more mistakes, is
Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message-
From: Keith Peterson [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 5:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERD generation tool
ERWin change the column sequences when using Reverse Engineering to generate
diagram. It puts all of primary key columns on the top. But, actually some
primary key columns are in the middle of table. That is really bad. Does
anybody see the same problem?
-Original Message-
Sent:
: Wednesday, May 01, 2002 6:17 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERD generation tool
ERWin change the column sequences when using Reverse Engineering to
generate
diagram. It puts all of primary key columns on the top. But, actually some
primary key columns
Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message-
From: Paul Li [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 6:17 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERD generation tool
ERWin change the column sequences when using Reverse
What version of ERWin are you using? Are you using ModelMart as well?
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, May 01, 2002 2:01 PM
To: Multiple recipients of list ORACLE-L
ERWin's not much better. Has some better modeling capability as you might
guess, but has some VERY
33063
-Original Message-
From: Paul Li [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 6:17 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ERD generation tool
ERWin change the column sequences when using Reverse Engineering to
generate
diagram. It puts all
Title: RE: ERD generation tool
When I was in an NT shop, we used Visio (I know...I know), but given that I was not architecting at the time, I can't compare with the Erwin that I am using now.
I remember at the time though, the ERDs created using Visio were accurate for what we were doing
Both Designer and ERwin can reverse engineer enough information from an
existing
database to generate an ERD.
Cherie Machler
Oracle DBA
Gelco Information Network
Yes, there is ERWin. You load the sql*plus scripts into it and it will then
re-engineer the diagrams.
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 7:24 AM
Can anyone please recommend/advise on NT/W2K
ERWin www.ca.com
ERStudio www.embarcadero.com
Active Designer http://www.iraje.com/ad_fsmain.htm
HTH
Mark
-Original Message-
Sean
Sent: 30 April 2002 13:24
To: Multiple recipients of list ORACLE-L
Can anyone please recommend/advise on NT/W2K compliant solutions which can
generate
Sean - Does your schema have all relationships like foreign keys defined?
Otherwise you just end up with a bunch of disconnected boxes. Hardly worth
the trouble.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, April 30, 2002 9:04 AM
To: Multiple
any idea on the pricing for these tools? I dont see a price on any of these
sites.
Ray
Mark Leith [EMAIL PROTECTED]
Reply-To :
[EMAIL PROTECTED]
To : Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject :
RE: ERD generation tool
Date :
Tue, 30 Apr 2002 06:03:36 -0800
ERWin
[EMAIL PROTECTED]
Reply-To :
[EMAIL PROTECTED]
To : Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject :
RE: ERD generation tool
Date :
Tue, 30 Apr 2002 06:03:36 -0800
ERWin www.ca.com
ERStudio www.embarcadero.com
Active Designer http://www.iraje.com/ad_fsmain.htm
HTH
Mark
on the pricing for these tools? I dont see a
price on any of
these
sites.
Ray
Mark Leith [EMAIL PROTECTED]
Reply-To :
[EMAIL PROTECTED]
To : Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Subject :
RE: ERD generation tool
Date :
Tue, 30 Apr 2002 06:03:36 -0800
ERWin www.ca.com
ERStudio
46 matches
Mail list logo
