Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: temp tablespace
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. Granted it is not much fun without anything
else, but
strictly speaking that is all that is required.
> >
> > 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 - 00:38:59 CDT