1.現在的視圖

?select to_lob(text) from SYS.DBA_views where view_name='XXX';

2.查舊數據

--as of timestamp to_date('2024-05-28 10:30:00','yyyy-mm-dd hh24:mi:ss')

?select to_lob(text) from SYS.DBA_views as of timestamp to_date('2024-05-28 10:30:00','yyyy-mm-dd hh24:mi:ss') where view_name='XXX';

3.long字段

text是long字段，用to_lob(text)轉成clob

4.建新表存數據或入庫某張表

--記得表前加模式/用戶名 
create table a1.test_a_20240528 as select to_lob(text) text from SYS.DBA_views as of timestamp to_date('2024-05-28 10:30:00','yyyy-mm-dd hh24:mi:ss') where view_name='XXX';insert into a1.test_a_20240528  select to_lob(text) from SYS.DBA_views as of timestamp to_date('2024-05-28 10:30:00','yyyy-mm-dd hh24:mi:ss') where view_name='XXX';
--用入庫記得提交
commit;