784091 wrote:The error message is telling you DDL is not allowed, that's not an error message i'd expect to see from a merge command (which does only DML).
I have two database, one is 10g R2 as server and another one is 9i R1 as remote database.
I have create public database link from the 9i database and execute MERGE command from 9i database.
But, I got the following error :
MERGE INTO TERRITORY@mv a
ERROR at line 1:
ORA-02021: DDL operations are not allowed on a remote database
Please, provide me the solution....
9i and 10g are labels given to market Oracle, they are not actual version numbers.
select * from v$version
784091 wrote:Well, you're working with a very old and unpatched version here.
Version of 9i :
Oracle9i Enterprise Edition Release 220.127.116.11.1 - Production
PL/SQL Release 18.104.22.168.1 - Production
CORE 22.214.171.124.1 Production
TNS for 32-bit Windows: Version 126.96.36.199.0 - Production
NLSRTL Version 188.8.131.52.1 - Production