thanks! ....i seem to look over details like this a little too often. :)
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Mercadante, Thomas F
Sent: Tuesday, August 24, 2004 9:27 AM
To: 'oracle-l@(protected) '
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@(protected)]=20
Sent: Tuesday, August 24, 2004 10:21 AM
To: oracle-l@(protected)
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;
