Re: oracle alter table question

From: Peter <rman9i_at_yahoo.com>
Date: Thu, 9 May 2002 11:26:55 -0400
Message-ID: <xAwC8.380$f5.1233159@mencken.net.nih.gov>

ALTER TABLE table_name

MODIFY(column_name VARCHAR2(xx))

"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 - 10:26:55 CDT