I know that for changing the lenght of a non-key column, we can do so without dropping the tablespace (by using ALTER TABLE). My question is that for changing the length of a key column, do we need to drop the tablespace and then recreate it using the new length of the column or can we do so without dropping the tablespace (by using ALTER TABLE)?
Looking forward to an early response. Thanks in advance.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
I need it urgently
If this is needed immediately, i suggest using the method you are already familiar with (after taking a backup). This will be much safer and should avoid any problems/surprises and will get you back up and running predictably.
Keep in mind that changing this column length may have and impact on other tables/processes that use this column.