I am trying to extend the length on a column of a table by 3 bytes.
It's a CHAR field. The table has about 17.5 million rows and 11 GB in size. Even though I have extended the tablespace by 4 GB, I am still getting an error
" ORA-01653: unable to extend table XXXX by 163840 in the tablespace"
What exactly goes on when we do this step. Can somebody explain.
Maybe you have row chaining starting. Worst case: adding 3 bytes to each row makes *each* row chain into a second block, the table's size would *double* instead of increasing by the 50Mb or so implied by 17.5mil x 3bytes...
Are the existing rows prehaps crafted with all fixed size column data type to exactly fit into one block?