|
|
| Author |
Message |
tarun_bhardwaj
New User
Joined: 18 Jul 2003
Posts: 14
Location: delhi
|
|
|
|
Hi,
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. |
|
| Back to top |
|
 |
References
|
 Posted: Thu Apr 24, 2008 10:59 am Post subject: Re: Column length change |
|
|
|
|
dick scherrer
Global Moderator
Joined: 23 Nov 2006
Posts: 7997
Location: 221 B Baker St
|
|
|
|
Hello,
| Quote: |
| 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. |
|
| Back to top |
|
|
|
|
