Oracle 11g new feature - fast add new column with default value
There is a new feature introduced from Oracle 11g, when add new column with default value, it will not update every row in the table but only save in the dictionary instead. But it doesn't work in my case.
My Db version is 11.2.0.3,
alter table MET.MET_TRACE_POINT add OGG_KEY_ID varchar2(255) default RAWTOHEX(sys_guid()) not null;
it failed ERROR at line 1: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO'
Elapsed: 01:38:05.04
Is there any recommendation for this?
Thanks!
Alice