Executing CTAS statement having TO_LOB(LONG COLUMN).
For example:
create table blah as
select GNT_ID.nextval, 1060 as gnt_ref_id, org.gnt_id, org.gnt_group_note, org.gnt_language,
to_lob(org.gnt_text_string) as gnt_text_string, org.gnt_text_emphasize
from asra_002.gnt_groupnote_txt org
where org.gnt_group_note in (select gnr_note from asra_002.gnr_groupnote_ref)