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
- Cherie_Machler_at_gelco.com 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
> <ORACLE-L_at_fatcity.com>
> yahoo.com> cc:
>
>
> Sent by:
> Subject: Re: Working with Oracle Designer
>
> root_at_fatcity.com
>
>
>
>
>
>
>
>
> 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 ?
>
>
>
>
> --- Cherie_Machler_at_gelco.com 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
> > <ORACLE-L_at_fatcity.com>
> > yahoo.com> cc:
> >
> >
> > Sent by:
> > Subject: Working with Oracle Designer
> >
> > root_at_fatcity.com
> >
> >
> >
> >
> >
> >
> >
> >
> > 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
> > stephane_paquette_at_yahoo.com
> >
> >
>
> > 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
stephane_paquette_at_yahoo.com
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: stephane_paquette_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Thu May 09 2002 - 13:48:47 CDT