| temporary tablespace [message #68097] |
Tue, 12 November 2002 12:52  |
ay4747
Messages: 1
Registered: November 2002
|
Junior Member |
|
|
We have a problem with a instance : we receive frequeltly the error " ORA-01575 timeout waiting for space management " . I found out on this site that the problem could be cause by the temporary tablespace being created PERMANENT :
SVRMGR> select * from sys.dba_tablespaces where tablespace_name = 'TEMP';
TABLESPACE_NAME INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT PCT_INCREA MIN_EXTLEN STATUS CONTENTS LOGGING EXTENT_MAN ALLOCATIO PLU
------------------------------ ---------- ---------- ---------- ---------- ---------- ---------- --------- --------- --------- ---------- --------- ---
TEMP 4096000 4096000 1 150000 0 0 ONLINE PERMANENT LOGGING DICTIONARY USER NO
1 row selected.
SVRMGR>
What could be the command to alter this temporary tablespace from PERMANENT to TEMPORARY ? IS there a " alter tablespace ...." command to change the temporary tablespace from PERMANENT to TEMPORARY ? What could be the impact of doing this commnad on a live instance ?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
