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_at_aya.yale.edu
On 11/15/05, Strickland, Mark <mark.strickland_at_cingular.com> 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
>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 15 2005 - 20:32:25 CST
