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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Reducing a column's width

Re: Reducing a column's width

From: Alan Shein <alanshein_at_erols.com>
Date: Mon, 22 Nov 1999 15:17:43 -0500
Message-ID: <81c8cb$hua$1@autumn.news.rcn.net>


Make space. You need two tables at some point.

BTW, I'm assuming that the column is not a VARCHAR2. Being that you are a newbie, I'll just mention that a VARCHAR2 does not take up the maximum amount of space allotted for it. Each row uses only what it needs plus a very small overhead.

<newbie22_at_my-deja.com> wrote in message news:81c6c3$epq$1_at_nnrp1.deja.com...
> HI all,
>
> How can I change a column's width,
> where the column is not currently empty?
>
> You can't do it with ALTER TABLE,
> because the field is not empty.
>
> So far, I don't think that you could
> export the data (with the unix utility exp)
> because you export the entire table structure,
> and all the associated data.
>
> You could do it by creating another table:
> Create table new_table as
> (Select substr(fieldname ) field_name,
> etc.
> )
>
> However, we don't have enough space left to
> do this.
>
> Any suggestions?
>
> Newbie
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 22 1999 - 14:17:43 CST

Original text of this message

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