Message-Id: <10711.124737@fatcity.com>
From: "Joseph S. Testa" <teci@oracle-dba.com>
Date: Fri, 15 Dec 2000 14:01:09 -0500
Subject: Re: Alter column size

but only if you're platying with 8i for the drop column feature,
amazingly there are still ALOT of shops paying with 8.0 and below.

joe
> Alex Hillman wrote:
> 
> You can also add column to current table instead of another table,
> move data to that column, modify existing column and copy data from a
> new column to modified column using
> 
> update <table name> set old_column=new_column
> and the drop new column.
> 
> Alex Hillman
> 
> -----Original Message-----
> From: Joseph S. Testa [mailto:teci@oracle-dba.com]
> Sent: Friday, December 15, 2000 7:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Alter column size
> 
> you can increase usually with no problem but to shrink you'll need to
> pull the data out to another table,null the column, reset the size and
> 
> push the data back, just be ready for "value too large for column"
> errors.
> 
> Joe
> John Dunn wrote:
> >
> > Can I alter a column size without recreating a table?
> >
> > Oracle version is 8.0
> >
> > John
>
-- 
Joe Testa  http://www.oracle-dba.com
No you can't fix an ORA-600 error, call Oracle Support.