Home » RDBMS Server » Enterprise Manager » temporary tablespace
temporary tablespace [message #68097] Tue, 12 November 2002 12:52 Go to next message
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 ?
Re: temporary tablespace [message #68098 is a reply to message #68097] Wed, 13 November 2002 11:56 Go to previous message
Mahesh Rajendran
Messages: 10699
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
just bring the tablespace offline. ( make sure no one is using this)
drop and recreate it with correct setttings..
Previous Topic: 2 orcle servers - 1 OEM
Next Topic: Node discovery fails
Goto Forum:
  


Current Time: Tue May 24 00:45:28 CDT 2022