INSERT INTO T_RIBAOGUANLI_WK
(NO, RIBAO_NO, USER_CD, COMPANY_CD)
SELECT ROWNUM AS NO, RIBAO_NO, '000001' AS USER_CD, COMPANY_CD
FROM (SELECT /*+ driving_site(V_ALL_RIBAO) */
DISTINCT RIBAO_NO,
COMPANY_CD,
GROUP_NAME,
NEIRONG
FROM V_ALL_RIBAO@MAINDBLINK
WHERE 1 = 1
AND ((CONTAINS@MAINDBLINK(NEIRONG, '"%c%" OR "%z%"') > 0))
ORDER BY RIBAO_NO DESC)
ORDER BY NO
第三行以下的SELECT可以正常查询,加入INSERT INTO就会报错
补充:远程链接查询时的条件里面有用到全文索引(CONTAINS),不用全文索引的话可以正常插入