Re: DEFAULT TEMP TABLESPACE

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 11 Jul 2007 16:30:54 -0700
Message-ID: <1184196654.080935.9270@w3g2000hsg.googlegroups.com>

On Jul 11, 6:04 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jul 11, 2:16 pm, NITIN <mahima.ni..._at_gmail.com> wrote:
>
> > Hi
>
> > Need to confirm if we can one more then one default temp tablespace
> > for a user.
>
> > Thanks,
> > 'N'
>
> Well, searching the docs for "temporary tablespace" leads more or less
> directly tohttp://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tspace...
>
> But you knew that, right?
>
> jg
> --
> @home.com is bogus.http://www.flickr.com/photos/andyarmstrong/725344106/in/photostream/

NITIN, if your Oracle version is 9.2 or lower the answer is a user may have only one default temporary tablespace. With 10g the default temporary tablespace can be a tablespace group as Joel referenced.

HTH -- Mark D Powell -- Received on Wed Jul 11 2007 - 18:30:54 CDT