Will it not use the default temp TS of the Database?
On 9/26/05, Kennedy, Jim <jim_kennedy_at_mentor.com> wrote:
>
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org on behalf of DBA Deepak
> Sent: Sun 9/25/2005 9:37 PM
> To: oracle-l_at_freelists.org
> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 26 2005 - 00:34:49 CDT
