Re: Expanding varchar2 column
- From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 15 Nov 2005 21:30:17 -0500
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:
