thanks! ....i seem to look over details like this a little too often. :) -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F Sent: Tuesday, August 24, 2004 9:27 AM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: odd problem when changing a datatype on table Chris, In the first crate table/select statement, you explicitely selected the columns you wanted from the order_log table (col1, col2, to_number(col3)). In the insert/select statement, you are doing a select *. You now need to do a column by column comparison between the two tables. You will find a column mis-match - maybe a number column trying to be inserted into a date column? Hope this helps. Tom Mercadante Oracle Certified Professional -----Original Message----- From: Chris Stephens [mailto:ChrisStephens@xxxxxxxxxx]=20 Sent: Tuesday, August 24, 2004 10:21 AM To: oracle-l@xxxxxxxxxxxxx Subject: odd problem when changing a datatype on table Here's what i did: =20 create table order_log2 as select cola, colb, to_number(colc) colc,... from order_log; =20 truncate table order_log =20 alter table order_log modify (colc number); =20 insert into order_log select * from order_log2; =20 ......and i get: =20 ERROR at line 1: ORA-00932: inconsistent datatypes: expected NUMBER got DATE =20 what gives? =20 it's not even on the column who's datatype i changed. =20 =20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------