Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: LMT and Siebel/Peoplesoft?

Re: LMT and Siebel/Peoplesoft?

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 22 Jan 2002 02:31:40 GMT
Message-ID: <ga438.7828$Qs4.16086@rwcrnsc53>


Yes it does. You need to read the documentation on installing on Oracle. You edit a file and add
space=TABLESPACE_NAME
for those objects that you don't want in the default. Jim
"Vikas Agnihotri" <fornewsgroups_at_vikas.mailshell.com> wrote in message news:902027f8.0201210935.4eff0dac_at_posting.google.com...
> "Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message
news:<3C4B368E.8988E9E5_at_exesolutions.com>...
> > Don't use one tablespace size. Create three or four for data and three
or four for indexes. For example
> >
> > data_sml 256K
> > data_med 2.5M
> > data_lrg 25M
> > data_ext 250M
>
> Thats what I wanted to do as well, but unfortunately, the Siebel
> install/upgrade process doesnt allow you to specify the tablespace
> with that degree of control.
>
> It just asks you for a data tablespace and a index tablespace. Then it
> proceeds to create all the objects with (I think) no STORAGE clause in
> its CREATE statements. For objects with a high growth rate, it uses
> the old PCTINCREASE concept, which Oracle would ignore anyway for a
> LMT.
>
> Thanks for the ideas.
Received on Mon Jan 21 2002 - 20:31:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US