| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Best Uses for Oracle Designer 2000?
<FONT face=Arial color=#0000ff
size=2> Tom, Jack,
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial
color=#0000ff size=2>Thank you for sharing your invaluable experience. Can you
shed some light, how do you estimate impact of database changes (anythimng,
changing view's or procedure interface ) on application? How do you (or
developers) know in advance, what pieces of code need to be revised in this
case, especially when the project is, say, large? As far as I see, there is no
central repository in your environment. Of course, I understand, best practice
addressing these issues do not make such changes at all, but in case? Anybody in
this list has technology helping database-application (say Java, or VB whatever)
dependency tracking?
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial
color=#0000ff size=2>Thank you
<FONT face=Arial
color=#0000ff size=2>Vadim Gorbounov
<FONT face=Arial
color=#0000ff size=2>Oracle DBA
<FONT face=Tahoma
size=2>-----Original Message-----From: Mercadante, Thomas F
[mailto:NDATFM_at_labor.state.ny.us]Sent: Friday, September 21, 2001
9:00 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Best Uses for Oracle Designer 2000?
<SPAN
class=380564511-21092001>David,
<SPAN
class=380564511-21092001>
I
agree with Jack.
<SPAN
class=380564511-21092001>
I
have not used Designer for generating applications (have tried, but not been
successfull - clearly because I did not have the time).
<SPAN
class=380564511-21092001>
But
I use it exclusively for database design and object creation (TbSpaces,
tables, indexes, PK's, FK's, CK's, Seq's, Trigs & Views). It is
great for buidling all of the relatioinships and then generating the DDL
scripts. Once you learn how it works, it is *much* faster than
maintaining sql scripts for all of your database objects.
<SPAN
class=380564511-21092001>
I
agree, that there is a learning curve. But, you can "reverse engineer" a
small database, and see how everything is stored to learn what needs to be
done where.
<SPAN
class=380564511-21092001>
I do
not keep PL/SQL (except for triggers) in the repos, mostly because I don't see
the benefit. The tool does not help you develop the scripts (we use
Toad), so storing them in the repos makes no sense to me (our developers use
SourceSafe for code managment).
<SPAN
class=380564511-21092001>
Hope
this helps.
Tom Mercadante <FONT face=Arial
size=2>Oracle Certified Professional
<FONT face=Tahoma
size=2>-----Original Message-----From: Jack C. Applewhite
[mailto:japplewhite_at_inetprofit.com]Sent: Thursday, September 20,
2001 7:30 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Best Uses for Oracle Designer
2000?
<SPAN
class=656060022-20092001>David,
<SPAN
class=656060022-20092001>
<SPAN
class=656060022-20092001>I've used Designer (and Oracle*CASE before it) for
about 10 years now. I've always used it for logical data modelling and
physical database implementation. In my Developer past, I've done a
ton of Oracle Forms and Reports generation from Designer, as well as Web
Server Generator apps. All my PL/SQL stored packages have always (and
still do) live in Designer.
<SPAN
class=656060022-20092001>
<SPAN
class=656060022-20092001>Now that I'm focussed on Development DBA work, I
user Designer for physical database design and implementation and PL/SQL
package development. It is wonderful for specifying tables, along with
their constraints, indexes, triggers, etc., etc. then generating
the DDL scripts to create the objects. Designer even lets you
deploy the same object, such as a table, with different storage parameters
to different databases - say, development, test, and
production.
<SPAN
class=656060022-20092001>
<SPAN
class=656060022-20092001>The reverse engineering functionality (called
"Design Capture" in the tool) of Designer is extremely useful. You
don't have to create all the objects of a database by hand, just point
Designer at a schema and let it suck up all the details into the Designer
Repository - a real time saver.
<SPAN
class=656060022-20092001>
<SPAN
class=656060022-20092001>There is definitely a *steep* learning curve
associated with Designer and the benefits of the tool are more along the
lines of quality, consistency, impact analysis, etc. rather than more rapid
development and/or deployment. Get some (or lots) of training
and hire a Designer "Guru" to spend some time with you showing you some
good techniques for doing what you want to do. Don't get an expert in
Oracle Forms generation to help you with Designer's DBA functionaliy,
however. Get the "Guru" that has the specific expertise you
need. Check out the Oracle Development Tools User Group (ODTUG) at <A
href="http://www.odtug.com">www.odtug.com for info on how to
subscribe to the Designer (and other) lists, which are hosted along with
this list right here at FatCity.
<SPAN
class=656060022-20092001>
<SPAN
class=656060022-20092001>Designer is HUGE, but you can successfully and
profitably use just the pieces you want.
<SPAN
class=656060022-20092001>
<SPAN
class=656060022-20092001>Jack
--------------------------------Jack C.
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8
DBAiNetProfit, Inc.Austin,
<FONT face=Tahoma
size=2>-----Original Message-----From: root_at_fatcity.com
[mailto:root_at_fatcity.com]On Behalf Of David WagonerSent:
Thursday, September 20, 2001 4:45 PMTo: Multiple recipients of
list ORACLE-LSubject: Best Uses for Oracle Designer
2000?
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Is
anyone out there deriving much benefit from Oracle Designer 2000?<SPAN
style="mso-spacerun: yes"> My company has the product and I
set it up but it looks like the initial investment in learning the product
and creating everything in the repository will be extremely
time-consuming. So, please
tell me your favorite uses for
Designer.
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Thanks,
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">David
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<span
face=Arial color=blue><SPAN
style="FONT-WEIGHT: bold; COLOR: blue; FONT-FAMILY: Arial">David B.
Wagoner
<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-STYLE: italic; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Database
Administrator<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-STYLE: italic; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Arsenal
Digital Solutions Worldwide Inc.<FONT face=Arial
color=black size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">4815
Emperor Blvd., Suite 110<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Durham,
NC 27703<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Tel.
(919) 941-4645<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Fax
(919) 474-0695<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Email
<FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'">mailto:dwagoner_at_arsenaldigital.com<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Web
<FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'">http://www.arsenaldigital.com/<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> <FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN
style="mso-spacerun: yes">
*** NOTICE<SPAN
style="mso-spacerun: yes"> ***<FONT face=Arial
color=black size=1><SPAN
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">This
e-mail message is confidential, intended only for the named recipient(s)
above and may contain information that is privileged, work product or
exempt from disclosure under applicable law.<SPAN
style="mso-spacerun: yes"> If you have received this message
in error, or are not the named recipient(s), please immediately notify the
sender at (919) 941-4645 and delete this e-mail message from your
computer. Thank
you.<SPAN
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<FONT
color=black> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
Received on Fri Sep 21 2001 - 08:23:42 CDT
 |
 |