Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Alter column size

Re: Alter column size

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Fri, 15 Dec 2000 14:01:09 -0500
Message-Id: <10711.124737@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US