Re: SYSTEM tablespace

If indeed the product create a schema userid with defaults in system, send it back; the product is not well designed.

But if the product expects you to create a schema id, then you should cause the default tablespace(s) for that id
to be one(s) you have alrady created with sufficient space to handle the product in an efficient manner. This kind of implementation is better, allowing a certain amount of "configuration" to be possible where size and complexity show a need for additional space of sharing of instances.   

kvsraju_at_my-dejanews.com wrote:
>
> In article <36FFDAA5.87C4FADC_at_tumbleweed.com>,
> David Dodini <david_at_tumbleweed.com> wrote:
> > Hello,
> >
> > I was doing an installation of a product that creates a schema in an
> > Oracle database this morning. The following error was returned to me
> > during this part of the installation:
> >
> > *******
> > ERROR at line 1:
> > ORA-01658: unable to create INITIAL extent for segment in tablespace
> > SYSTEM
> > *******
> >

--
Gerry Sinkiewicz
sinkiege_at_snet.net Received on Mon Apr 05 1999 - 17:20:28 CDT