Re: Temporary Table Space Abuse

No, but you can make your temp tablespace temporary. This is better for performance because the space allocated in a temporary tablespace would only be freed if the instance is shut down and sort do not have to allocate and disallocate space in a temporary tablespace.
But notice that objects created in this tablespace will be droped on instance shutdown !!

 Mario Bucsics

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!