RE: odd problem when changing a datatype on table
- From: "Chris Stephens" <ChrisStephens@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Aug 2004 09:30:51 -0500
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
-----------------------------------------------------------------
Other related posts:
