Temp tablespace with tempfile and locally managed with uniform extent size is the best practice with 8i onward.
The right place to check temp usage is V$sort_usage. After reaching high watermark those extents are not released and kep for future use and it is a normal behaviour.
Always check v$sort_usage for temp tablespace usage.
About your problem, it looks you have insufficient temp tablespace and may increase and retry. If you are rebuilding inex with parallel clause then it creates mulitple temp extents (equal to parallel degree specified) and requires more temp space/
If you have any specifc question, you may ask to this list.
HTH,
Regards Rafiq
Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 05 Sep 2003 05:59:27 -0800
HI all,
I'm getting the following error when using temporary tablespace on a locally managed system tablespace. Seems if my system tablespace is locally managed I can not create a dictionary managed tablespace.
Can anyone let me know if it is a bad idea to have system tablespace locally managed and why I am getting the following the error on building an index:
ERROR at line 1: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01
Also, I issue the following query and looks like the tempoary tablespace is not being free'ed up( or maybe this is not what this v$ tables is telling me):
select tablespace_name, file_id,bytes_used,bytes_free from v$temp_space_header; SQL> select tablespace_name,file_id,bytes_used,bytes_free 2 from v$temp_space_header; TABLESPACE_NAME FILE_ID BYTES_USED BYTES_FREE ------------------------------ ---------- ---------- ---------- TEMP01 2 2146435072 0
Thanks in advance. Lizz
--------------------------------- Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
_________________________________________________________________
Try MSN Messenger 6.0 with integrated webcam functionality! http://www.msnmessenger-download.com/tracking/reach_webcam
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
