Re: Expanding varchar2 column

Mark,

I'd think that the procedure would be the same regardless of the table's row
count--have you considered creating a similar table, enabling trace, and
inspecting the trace file?

--
Paul Baumgartel
paul.baumgartel@xxxxxxxxxxxx

On 11/15/05, Strickland, Mark <mark.strickland@xxxxxxxxxxxx> wrote:
>
> A co-worker needs to modify a varchar2 column from 100 bytes to 200 bytes
> in a large table. We think that it will just modify the data dictionary and
> not do a full table scan. Does anyone know for sure? Yep, I've RTFM'd and
> google'd and metalink'd it. Thx.
>  Mark Strickland
> Seattle, WA
>

Other related posts: