changing datatype

From: <iashraf_at_csc.com>
Date: Mon, 11 Feb 2002 05:00:47 -0800
Message-ID: <F001.0040B8B1.20020211041823@fatcity.com>

hi,

i have a column set to NUMBER , i want to change it to NUMBER(10);

is there any way of doing this without having to delete the data and avoid the error
ORA-01440: column to be modified must be empty to decrease precision or scale
using 8.1.7

cheers..

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: iashraf_at_csc.com

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). Received on Mon Feb 11 2002 - 07:00:47 CST