Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Expanding varchar2 column

Expanding varchar2 column

From: Strickland, Mark <mark.strickland_at_cingular.com>
Date: Tue, 15 Nov 2005 15:28:19 -0800
Message-ID: <184BC2BEE669AD45BDAF01FD5F6A2F5D6BA300@WA-MSG11-BTH.wireless.attws.com>


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 - 17:31:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US