Table size never affected the speed of this particular operation on any Oracle version for us, for any heap organized table, partitioned or not. Did it a lot of times, was never a problem.
Actually, problems appear after the modification.
BTW: Oracle was saying that data type length and precision modifiers are check constraints in fact, data is still stored in a variable length format (at least for varchar2 and number.)
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Strickland, Mark
Sent: 15. nóvember 2005 23:28
To: oracle-l_at_freelists.org
Subject: Expanding varchar2 column
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 Wed Nov 16 2005 - 08:43:09 CST
