RE: Expanding varchar2 column

Thank you!  

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Laimutis Nedzinskas
	Sent: Wednesday, November 16, 2005 6:40 AM
	To: Oracle-L_at_freelists.org
	Subject: RE: Expanding varchar2 column
	
	
	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