Re: temp tablespace

"Sean Fitzgerald" <sfitzgerald_at_centurytel.net> wrote in message news:%tii7.3913$tE2.1545393_at_feed.centurytel.net...
> You do not need a temporary tablespace to have an instance. A temporary
> tablespace
> provides the area to perform sorts, but is not a requirement. An instance
> will start just fine
> without one. All you require is the system tablespace, some redo logs and
> the associated oracle background
> processes to have an instance.

Precision, please. An Instance no more requires a system tablespace than it requires a controlfile. What state do you get to *create* the system tablespace in the first place? Er... NOMOUNT... which means... er, "I have an Instance but nothing else".

>Granted it is not much fun without anything
> else, but
> strictly speaking that is all that is required.

Strictly speaking, all you require is RAM in which to create the Instance.

Regards
HJR
>
>
>
> > >
> > > A temporary tablespace needs to be set up to have an Oracle instance.
> > >
> > > If you don't know why you need a temp tablespace you know far too
little
> > to
> > > even consider the kinds of questions you have floating in your mind.
> > >
> > > Get a good book on Oracle Architecture or a decent DBA book and start
> > reading
> > > it.
> > >
> > > To explain to you how far out in space you are would take a lot of
time.
> > >
> > > Daniel A. Morgan
> > >
> >
> >
>
>
Received on Mon Aug 27 2001 - 05:39:32 CDT