you can increase usually with no problem but to shrink you'll need to
pull the data out to another table,null the column, reset the size and
push the data back, just be ready for "value too large for column"
errors.
Joe
John Dunn wrote:
>
> Can I alter a column size without recreating a table?
>
> Oracle version is 8.0
>
> John
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dunn
> INET: john.dunn_at_sefas.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Joe Testa http://www.oracle-dba.com
No you can't fix an ORA-600 error, call Oracle Support.
Received on Fri Dec 15 2000 - 06:49:02 CST
