RE: Best Uses for Oracle Designer 2000?

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Thu, 20 Sep 2001 15:35:30 -0700
Message-ID: <F001.00394386.20010920153018@fatcity.com>

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" 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 Thu Sep 20 2001 - 17:35:30 CDT