No, it is
generally better practice to use temporary tablespace for the following
reasons.
1. You will
not accidentently store objects in it.
2. Reduced
contention for the ST enqueue
3.
Reduce backup and recovery time
"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
From: Amar Kumar Padhi [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 8:11 AM
To: Multiple recipients of list ORACLE-L
Subject: Permanent Tablespace for sorting.
Oracle recommends creation of separate temporary tablespace for sort operations.
Is there any advantage in using a permanent tablespace instead of a temporary for sort operations?rgds
amar