| Probs with UndoTBS ORA-1652 [message #142099] |
Thu, 13 October 2005 08:29  |
marrec
Messages: 35
Registered: May 2005
Location: Mühlheim, Germany
|
Member |
|
|
hey there,
i have big prob with an UndoTBS:
ORA-1652: unable to extend temp segment by 8 in tablespace UNDOTBS
normally i thought, oracle would perform a rollback after this error and everything is okay again, but in this case, i cannot use the undotbs anymore. enterprise manager says the undotbs size is 0MB! In the OS-Filesystem it is 2GB. So i can't edit data now.
I tried to create a new undotbs and drop the old one, this works fine, but 2 days later, the same error occured again.
does somebody knows what to do?
thx
marrec
|
|
|
|
| Re: Probs with UndoTBS ORA-1652 [message #142108 is a reply to message #142099] |
Thu, 13 October 2005 08:51  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
scott@9i > show parameter undo_retention
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_retention integer 10800
What is your undo_retention?
Increase it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
