odd problem when changing a datatype on table 2004-08-24 - By Chris Stephens
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 (See ORA-00932.ora-code.com): 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
