Database Tuning (MOSC)

MOSC Banner

Oracle 11g new feature - fast add new column with default value

edited Jun 11, 2015 10:06AM in Database Tuning (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center