E_QE009D Alter Table ADD/DROP column support for pages greater than 2k

Post date: Feb 15, 2011 5:22:17 AM

When you get this error then you have to reconstruct ur page_size

modify tblbooks to reconstruct with page_size=4096;

alter table tblbooks add column status varchar(1);

It will execute successfully...