查出有可能引起ORA-01461错误的表

仅能绑定要插入 LONG 列的 LONG 值的解决方法

SELECT * FROM 
  (SELECT TABLE_NAME,OWNER,COUNT(*)NUM
  FROM DBA_TAB_COLUMNS
  WHERE DATA_TYPE='LONG'
  OR ((DATA_TYPE='VARCHAR2'
  OR DATA_TYPE='CHAR'
  OR DATA_TYPE='NVARCHAR2'
  OR DATA_TYPE='NCHAR')
  AND DATA_LENGTH>1333)
  AND OWNER NOT IN ('SYS','SYSTEM','SH','OLAPSYS','MDSYS','ODM','XDB','WMSYS') GROUP BY TABLE_NAME,OWNER)
  WHERE NUM >1 
  order by TABLE_NAME