I've found out how to generate without the storage clause.
--- paquette stephane <[EMAIL PROTECTED]> a �crit�: > 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 : > === 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).
