OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » UNDO TABLE SPACE (9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UNDO TABLE SPACE [message #482314]

Thu, 11 November 2010 01:01

vishalk
Messages: 33
Registered: October 2010

Member

Pls help me

i want to increase undo tablespace size..

but it gives an error

enable to extand the size.

i am write
alter database datafile 'path' resize 2000M;

tell me where i m wrong...

Report message to a moderator

Re: UNDO TABLE SPACE [message #482324 is a reply to message #482314]

Thu, 11 November 2010 01:17

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do NOT post your title in UPPER case.

Do not just explain what you did as you can't explain what you don't understand (and in addition you post some things wrong: your error message does not exist).
Show us: copy and paste your SQL*Plus session.

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Re: UNDO TABLE SPACE [message #482326 is a reply to message #482314]

Thu, 11 November 2010 01:23

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

ORA-30036:
unable to extend segment by string in undo tablespace 'string'
Cause: the specified undo tablespace has no more space available.
Action: Add more space to the undo tablespace before retrying the operation. An alternative is to wait until active transactions to commit.

Report message to a moderator

Re: UNDO TABLE SPACE [message #482328 is a reply to message #482326]

Thu, 11 November 2010 01:27

vishalk
Messages: 33
Registered: October 2010

Member

Hi Ramoradba,

i shutdown immediate database.
but after i open
it still not resize...

what can i do.

Report message to a moderator

Re: UNDO TABLE SPACE [message #482329 is a reply to message #482328]

Thu, 11 November 2010 01:29

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Thu, 11 November 2010 08:17

...
Do not just explain what you did as you can't explain what you don't understand (and in addition you post some things wrong: your error message does not exist).
Show us: copy and paste your SQL*Plus session.

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel