2个数据库,相互建立DBLINK,在其中一个数据库中进行远程INSERT INTO语句。请指教。
语句如下:
INSERT INTO RGXDD_EXCH_NUMDATA@DBLINK
(REGION, DISTRICT, NAME, CODE)
SELECT NVL(REGION, '<NO NAME>'), NVL(DISTRICT, '<NO NAME>'), NAME, CODE
FROM I_EXCH_NAME EXCH
报ORA-22804: remote operations not permitted on object tables or user-defined type columns错误,
语句如下:
INSERT INTO RGXDD_EXCH_NUMDATA@DBLINK
(REGION, DISTRICT, NAME, CODE)
SELECT NVL(REGION, '<NO NAME>'), NVL(DISTRICT, '<NO NAME>'), NAME, CODE
FROM I_EXCH_NAME EXCH
报ORA-22804: remote operations not permitted on object tables or user-defined type columns错误,
(REGION, DISTRICT, NAME, CODE)
SELECT NVL(REGION, null), NVL(DISTRICT, null), NAME, CODE
FROM I_EXCH_NAME EXCH;
http://dbawangf.spaces.live.com/Blog/cns!D9AC4868837BDC6A!215.entry不过,与此关系不大。
楼主先通过link查询一下是否正常,如果正常,在select 对应的列上加表名属主看看