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: Resizing

Re: Resizing

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 26 Oct 1999 15:35:04 +0200
Message-ID: <940944936.12964.0.pluto.d4ee154e@news.demon.nl>


What are you exactly up to?
If you want to enlarge a column in one of your own tables use
alter table <blabla> modify (<blacol> <column type>(<new size>));

This will automatically reflect in the datadictionary view you are referring too.
Oracle will not allocate anything until any occurence of the column get's bigger than it's previous size.

Do NOT modify the datadictionary itself, or you will be creating havoc, and Oracle will pull it's hands of your database.

Hth,

--
Sybrand Bakker, Oracle DBA
Tom Deckers <tdeckers_at_cisco.com> wrote in message news:940931057.430276_at_sj-nntpcache-2.cisco.com...
> Hi,
>
> How do I resize a field in an Oracle table. Is it enough to change the
> ALL_TAB_COLUMNS table or do I need to do something else?? What about the
> memory allocation for aa resized field? If you enlarge a certain field,
> will oracle allocate a NEW and bigger memory chunk?
>
> Thanks for your time,
> Tom Deckers.
>
>
Received on Tue Oct 26 1999 - 08:35:04 CDT

Original text of this message

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