How to insert value to a LONG data type?
846231Nov 9 2011 — edited Nov 9 2011Hi All,
The developers what to change the datatype of table PRODUCT.
PRODUCT
======
ID number(10) not null,
NAME varchar2(50) not null,
DESCR varchar2(250) not null
They want the DESCR to change datataype to LONG.
So I back it up first:
create table product_bak as select * from product;
delete product;
alter table product modify (descr null);
alter table product modify (descr long);
insert into product select * from product_bak;
ORA-997 - illegal use of LONG datatype
How can I recover my data back?
Thanks a lot.