RE: Best Uses for Oracle Designer 2000?

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 21 Sep 2001 05:11:25 -0700
Message-ID: <F001.00394870.20010921050018@fatcity.com>

David,

I
agree with Jack.

I have
not used Designer for generating applications (have tried, but not been successfull - clearly because I did not have the time). 
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.

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.

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).

Hope
this helps.
Tom Mercadante Oracle Certified Professional

-----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?
 David,
 
 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.
 
 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.
 
 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.
 
 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.
 
 Designer is HUGE, but you can successfully and profitably use just the pieces you want. 
 Jack

  --------------------------------Jack C.

ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,
Texaswww.iNetProfit.comjapplewhite_at_inetprofit.com(512)327-9068

-----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?

Is anyone out there deriving much benefit from Oracle Designer 2000? 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.


Thanks,

David

<span

style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail Signature" <FONT

color=blue face=Arial>David B. Wagoner
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-STYLE: italic; mso-bidi-font-size: 12.0pt">Database Administrator
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; mso-bidi-font-size: 12.0pt">Arsenal Digital Solutions Worldwide Inc.
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">4815 Emperor Blvd., Suite 110
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Durham, NC 27703
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Tel. (919) 941-4645
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Fax (919) 474-0695
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Email
<SPAN

    style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt">mailto:dwagoner_at_arsenaldigital.com<FONT 
    color=black face=Arial size=2><SPAN 
    style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">

<SPAN

style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Web
<SPAN

    style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt">http://www.arsenaldigital.com/<FONT 
    color=black face=Arial size=2><SPAN 
    style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">

<SPAN

    style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"> <FONT 
    color=black face=Arial size=2><SPAN 
    style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">

<SPAN

style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 8pt; mso-bidi-font-size: 12.0pt"><SPAN

    style="mso-spacerun: yes">

*** NOTICE ***
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 8pt; 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. 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.<SPAN

    style="mso-spacerun: yes">  Thank you.<FONT 
    color=black face=Arial size=1><SPAN 
    style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 8pt; 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 - 07:11:25 CDT