Re: Resizing

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