Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle alter table question
One way is to do this:
alter table rename the column to a new name. atler table add column with the old name and size you need update table1 set table1.data=table1.tempcolumn; then delete the tempcolumn and let that finish, takes a while. Then do a MOVE table to the same tablespace.
It will work. Now a VARCHAR2 should be able to gro no problem anyway... uping a size on a VARCHAR2 does nothing to how the data is stored. Not sure why you can not do that unless it is a CHAR
"Rayden" <durlecht_at_remove-this.msu.edu> wrote in message news:<abe2na$2gfn$1_at_msunews.cl.msu.edu>...
> hey,
>
> i have a table with which i need to change one of the columns, however
> because i have data in the tables it will not let me do this (oracle 8i).the
> column change is to increase a varchar in size. how in the world do i do
> this? i tried to exp the data, however it does the table as well. i am a
> little lost here, so any help would be appreciated.
>
>
> tom
Received on Thu May 09 2002 - 14:09:38 CDT