re to the dev
> > model
> > would be great because my development changes
would
> be
> > in the model,
> > not in
> > the test or production databases. In that
specific
> > case I had to TRUST
> > him
> > (what? trust him after what he just did?)
On Behalf 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
AIL PROTECTED]>
> > > Date: Wed, 1 May 2002 16:06:00 -0500
> > >
> > >
> > >
> > >
> > >
> > > Well, for one thing, if your developer, Dom Phoc,
> > > starts changing crap
> > > in
> > > your databa
02 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: [EMAIL PROTECTED]
Fa
ld
> be
> > in the model,
> > not in
> > the test or production databases. In that
specific
> > case I had to TRUST
> > him
> > (what? trust him after what he just did?) to
change
> > everything back,
> > or
> > restore from a backup, which wou
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
trust him after what he just did?) to
change
> > everything back,
> > or
> > restore from a backup, which would have been very
> time
> > consuming.
> >
> > I was one large ball of raging hormones that day
and
> I
> > took it all out
> > on
>
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:
http://www.iraje.com/Active
nal Message-
> From: Yechiel Adar [SMTP:[EMAIL 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 rul
> > not in
> > the test or production databases. In that specific
> > case I had to TRUST
> > him
> > (what? trust him after what he just did?) to change
> > everything back,
> > or
> > restore from a backup, which would have been very
> time
> >
cipients of list ORACLE-L
> Subject: Re: ERD generation tool - Active SCM
>
>
> Yechiel,
> Yes, I have been there, done that, over and over...
> But then, there is a "Toyota Corolla" solution and
> maybe a "Ferrari Testarosa" solution.
>
> If we can cont
that day and
I
> took it all out
> on
> him. We don't work on the same projects anymore.
>
> Lisa Koivu
> Oracle Database Administrator
> Fairfield Resorts, Inc.
> 5259 Coconut Creek Parkway
> Ft. Lauderdale, FL, USA 33063
>
>
> > -Original Message---
"Grabowy,
Chris" To: Multiple recipients of list
ORACLE-L
@fcg.com> cc:
Sent by: rootSubject: RE: ERD generation
tool
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 th
Parkway
Ft. 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 s
hormones that day and I
> took it all out
> on
> him. We don't work on the same projects anymore.
>
> Lisa Koivu
> Oracle Database Administrator
> Fairfield Resorts, Inc.
> 5259 Coconut Creek Parkway
> Ft. Lauderdale, FL, USA 33063
>
>
> > -Original Me
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) 53
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 d
--
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
-
t; To: Multiple recipients 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
I
can't trust a tool then I can't use it.
"Grabowy,
Chris" To: Multiple recipients of list
ORACLE-L
@fcg.com>cc:
Sent by: rootSubject: RE:
To: Multiple recipients of list
ORACLE-L
@fcg.com>cc:
Sent by: rootSubject: RE: ERD generation
tool
05/01/2002
06:56 PM
terson [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 with
the
> DATABA
Hello Ron
I was just looking at Joe new oracle 9i features at
http://www.oracle-dba.com
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 to know
Yechiel Adar
Mehi
@fcg.com>cc:
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 mª¿ªm
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
> Subje
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 (dr
erdale, 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 Eng
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
orts, Inc.
5259 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 ch
ED]]
> 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, act
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: Wednesd
abase 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:
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 bu
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 MATCH
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 report
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
-Original Message-
Sean
Sent: 30 April
Tuesday, April 30, 2002 2:38 PM
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 generatio
ites.
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 www.embarcadero.com
Active Designer http://www.i
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
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 re
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 ERD'
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
"O'Neill,
Sean"To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject:
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
Can anyone please recommend/advise on NT/W2K compliant solutions which can
generate ERD's by interogating the DB.
-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]
This message, includin
47 matches
Mail list logo
