Re: Resize Columns

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 14 Sep 1999 15:11:00 -0400
Message-ID: <np3eN7GysN7nE+Bveptn9Ii1TuZW@4ax.com>

A copy of this was sent to "In2Home User" <user_at_forlano.in2home.co.uk> (if that email address didn't require changing) On Tue, 14 Sep 1999 19:37:37 +0100, you wrote:

>I'm sure this is an age-old question, but
>can I resize the columns of an Oracle 8.0.5 table
>without having to drop and recreate the table?
>
>Thanks,
>
>Chris
>

Yes. alter table X modify ....

you can make them bigger

you can make them smaller -- IF they contain no data.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Sep 14 1999 - 14:11:00 CDT