Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: odd problem when changing a datatype on table

Re: odd problem when changing a datatype on table

From: Steve Jelfs <steve_at_trolltec.co.uk>
Date: Tue, 24 Aug 2004 15:26:55 +0100
Message-ID: <WorldClient-F200408241526.AA26550009@trolltec.co.uk>


Can't you just drop order_log and rename order_log2? Or am I missing something?

Steve    

-----Original Message-----
From: "Chris Stephens" <ChrisStephens_at_Affina.com> To: <oracle-l_at_freelists.org>
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_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Aug 24 2004 - 09:21:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US