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
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;
from v$temp_space_header;
SQL> select tablespace_name,file_id,bytes_used,bytes_free
2 from v$temp_space_header;
2 from v$temp_space_header;
TABLESPACE_NAME FILE_ID BYTES_USED BYTES_FREE
------------------------------ ---------- ---------- ----------
TEMP01 2 2146435072 0
------------------------------ ---------- ---------- ----------
TEMP01 2 2146435072 0
Thanks in advance.
Lizz
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
