Re: oracle alter table question

Tom,

I think you can expand the size of varchar2 columns. As a matter of fact, I did a simple test and here is what I got:

SQL> create table test ( field1 varchar2(1) );

Table created.

SQL> insert into test values ('a');

1 row created.

SQL> alter table test modify field1 varchar2(3) ;

Table altered.

SQL> select * from test;

FIE

---
a

SQL> 

So, probably you should try again

Eduardo

"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