|
View previous topic :: View next topic
|
| Author |
Message |
tarun_bhardwaj
New User
.jpg)
Joined: 18 Jul 2003
Posts: 39
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 |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
|
|
