Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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.Received on Fri Dec 15 2000 - 13:01:09 CST
![]() |
![]() |