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

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

RE: Expanding varchar2 column

From: Laimutis Nedzinskas <lnd_at_HNIT.is>
Date: Wed, 16 Nov 2005 14:39:51 -0000
Message-ID: <B201EF146906A446B13E38A111BD83791F591F@HNIT-SEIFUR>


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

Original text of this message

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