I've found out how to generate without the storage
clause.
- paquette stephane <stephane_paquette_at_yahoo.com> 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
> --- 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 :
>
=== 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 - 16:24:35 CDT