Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UNDOTBS1

user126684Dec 19 2013 — edited Mar 16 2014


Trying to build a primary key on a table that had over one billion rows in it . Getting ORA-30036: Unable to extend segment by 8 in undo tablespace 'UNDOTBS1'  Yes I can build a giant tablespace for it, but I was thinking just like autocommit being set on is there something I can use that would stop the tablespace from growing?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2014
Added on Dec 19 2013
3 comments
2,562 views