Error Description:
CREATE TABLE AS SELECT (CTAS) and Insert into command fails with ORA-00997: illegal use of LONG datatype
SQL> insert into test (select note from siebel.EIM_SR_DTL where rownum<10);
insert into test (select note from siebel.EIM_SR_DTL where rownum<10)
*