I've been looking for that in Designer , where it is ? I've used a lot Power*AMC in the past and it has that feature .
We're using Oracle Designer 6.5.52.1.0 TIA --- [EMAIL PROTECTED] a �crit�: > > Stephane, > > We have the same objects, etc. in both dev and prod. > > We only have a single database defined. When we > get to prod, we'll have to edit the tablespace > physical > storage definition (in just one place) to change the > datafile definitions. > > It is possible to use different methods to generate > DDL from the same definition. One method > generates > DDL that containts storage definitions and one does > not. You don't actually need to change the way > anything > is defined in Designer to switch back and forth > between the > two methods. > > Cherie > > > > > > paquette stephane > > > <stephane_paquette@ To: > Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > yahoo.com> cc: > > > Sent by: > Subject: Re: Working with Oracle Designer > > [EMAIL PROTECTED] > > > > > > > > > 05/08/02 04:03 PM > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > So you're generating specific DDL for each > environments. > Do you have 1 db in Designer per Oracle database ? > > Also, we have a requirement to be able to generate > the > DDL without any tablespaces and storage clause so > the > developers can do some prototyping in their own > space. > The way we will handle that is to create a user > no_storage for each user and to do table > implementation without tablespace. > Anybody working like that ? > > > > > --- [EMAIL PROTECTED] a �crit�: > > > Stephane, > > > > We are doing exactly that with Designer 6i. > > > > We are able to generate all the DDL except for > > public synonyms. > > No solution found for that. > > > > Otherwise, it is working well in our QA > environment. > > Haven't > > used it yet to generate prod but that is coming > next > > month. > > > > Cherie Machler > > Oracle DBA > > Gelco Information Network > > > > > > > > > > > > paquette stephane > > > > > > <stephane_paquette@ To: > > Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > yahoo.com> cc: > > > > > > Sent by: > > Subject: Working with Oracle Designer > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > 05/08/02 01:24 PM > > > > > > Please respond to > > > > > > ORACLE-L > > > > > > > > > > > > > > > > > > > > > > > > > > Hi, > > > > We're discussing ways of working with Designer. > > We convinced developpers to use the check in/check > > out > > stuff and each application has its many workareas. > > > > Someone here would like to press a button and have > > all > > the DDL generetad for at least 2 environments : > prod > > and dev (including datafiles path and sizing). > > Of course the physical files layout/sizing are > > different in dev, test, QA, prod and maintenance > > environments. > > > > One way we tought, is for each application, to > have > > a > > logical DB where we put all the schemas, tables, > and > > tablespaces. > > For the same application, we created 2 physicals > DB > > , > > lets called them dev and prod where we created the > > tablespaces with a storage definition. The storage > > definition would match the physical caracteristics > > of > > the db. > > > > So, when generating for dev, we use the dev > physical > > layout and when for prod we use the prod physical > > layout. > > > > Anybody working like that ? > > Other approach ? > > > > TIA > > > > ===== > > St�phane Paquette > > DBA Oracle, consultant entrep�t de donn�es > > Oracle DBA, datawarehouse consultant > > [EMAIL PROTECTED] > > > > > ___________________________________________________________ > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite > et > > en fran�ais ! > === message truncated === ===== St�phane Paquette DBA Oracle, consultant entrep�t de donn�es Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___________________________________________________________ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en fran�ais ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
