--步骤1:
create table tmp_user_view as
select t.VIEW_NAME,to_lob(t.text) text from user_views t;
--步骤2:
create table tmp_wrh_user_view2 as
select t.VIEW_NAME,dbms_lob.substr(t.text,3000) text from tmp_user_view t;
--超过3593 会报character string buffer too small 错误
view_name varchar2(30)
text varchar2(4000)