Re: Expanding varchar2 column

  • From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 15 Nov 2005 21:30:17 -0500


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

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: