Forum Stats

  • 3,770,713 Users
  • 2,253,156 Discussions
  • 7,875,555 Comments

Discussions

unable to extend segment by 8 in undo tablespace 'UNDOTBS1' error ?

644850
644850 Member Posts: 13
edited Sep 2, 2008 2:11AM in General Database Discussions
I have added a new column to one of my tables,and I am migrating data to fill all the existing rows for this newly added column; but while executing the migration script I get the following error -

Error:ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

Of whatever i searched on the net this error points to lack of space for the undo segment of oracle. is it possible to extend this space dynamically?

Any pointers to help me resolve the problem would be appreciated.

Thanks.
Tagged:

Answers

This discussion has been closed.