Can't you just drop order_log and rename order_log2? Or am I missing something? Steve -----Original Message----- From: "Chris Stephens" <ChrisStephens@xxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Date: Tue, 24 Aug 2004 09:21:03 -0500 Subject: odd problem when changing a datatype on table > Here's what i did: > > > create table order_log2 as select cola, colb, to_number(colc) colc,... > from order_log; > > > > truncate table order_log > > > > alter table order_log modify (colc number); > > > > insert into order_log select * from order_log2; > > > > ......and i get: > > > > ERROR at line 1: > > ORA-00932: inconsistent datatypes: expected NUMBER got DATE > > > > what gives? > > > > it's not even on the column who's datatype i changed. > > > > > ---------------------------------------------------------------- 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 -----------------------------------------------------------------