Re: Permanent TS for sorting
- From: DBA Deepak <oracle.tutorials@xxxxxxxxx>
- To: "Kennedy, Jim" <jim_kennedy@xxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 26 Sep 2005 11:02:50 +0530
Will it not use the default temp TS of the Database?
On 9/26/05, Kennedy, Jim <jim_kennedy@xxxxxxxxxx> wrote:
>
>
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of DBA Deepak
> Sent: Sun 9/25/2005 9:37 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Permanent TS for sorting
>
> Hi All,
>
> How can I use a permamnent tablespace for sorting operation as does the
> Temporary tablespace? Is it possible?
>
>
> --
> Regards,
>
> Deepak
> Oracle DBA
>
> Why? You would have to specify that the default tablespace for that user
> is the permanent one. Not as efficient as using the temporary one.
> Jim
>
>
--
Regards,
Deepak
Oracle DBA
Other related posts:
