Re: Designer 2.1 1 query

Hey, funny how somethings just slip on by. Was that in the earlier versions. Actually, I end up modifying the scripts mostly to assign my indexes to the appropriate tablespaces and usually just run them elsewhere but that is good to know. How about in the new version causing the scripts to assign indexes to the appointed tablespaces. In the earlier versions it worked according to my Designer info but since I upgraded, my indexes are tablespace-less thus ending up in my default tablespace. Thanks for your info. rq

Herman Viaene wrote:

> Robin,
>
> I don't quite understand your last point. When you generate the table from
> the designer, and you select the radio button "Database" you can specify any
> other user for which the generated scripts are to run. This user will then
> be the owner of the table.
>
> Robin Quasebarth wrote:
>
> > The way I do it is log into SQLPlus as the user that you want to own all
> > objects and run the scripts from there. Really would be nice to have
> > the option within Designer to specify a schema if it differs from the
> > user designing the db. rq
> >
> > Derek Mitchell wrote:
> >
> > > Is anyone using Designer 2.1.1 to generate build scripts?
> > > I'd like to be able to produce
> > >
> > > create table user.table
> > >
> > > rather than
> > >
> > > create table table
> > >
> > > but I don't see how this can be done.
> > >
> > > Regards,
> > >
> > > Derek
>
> --
> ******************************************************************
> ***** A L C A T E L B E L L S P A C E & D E F E N S E *******
> Herman Viaene
> Berkenrodelei 33, B-2660 Hoboken, Belgium
> Tel: (32/3)8295591
> Fax: (32/3)8295502
> OIS-mail: viaeneh_at_AM_at_BTMA97
> Internet-mail: viaeneh_at_btmaa.bel.alcatel.be
> X400: Viaene Herman (C=BE,A=RTT,P=ALCANET,OU1=BELA1,O=ALCATEL,
> S="Viaene",G="Herman")
> ******************************************************************
Received on Tue Dec 15 1998 - 00:00:00 CET