Hi Gurus,
i have one table with one long column.Below structure this
A (s0 number,s1 long,s2 varchar2(20))
Above long column contains "select" Query. A table contains 400 records.
I want to create backup table for the TABLE A
create table A_BKP as select * from A;
when i am trying to create got the below error LIKE
ORA--00997: illegal use of LONG datatype;
so i request you, is there any other way to create the backup table using LONG column.
Thanks & Regards
Rock