Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The DDL command cannot be executed directly with the database link on the remote database. If it is run, it will cause the error as follows.
ORA-02021: DDL operations are not allowed on a remote database.
The dbms_utility.exec_ddl_statement procedure must be used for this. With this procedure, any DDL command can be executed in the remote database. In this way, all operations can be done from a single point.
Sample use:
1 | SQL> exec dbms_utility.exec_ddl_statement@DB_LINK('TRUNCATE TABLE USER.TABLO_NAME'); |
In the above example, DB_LINK specifies the database link. After that, the command is executed in parenthesis and single quotes.
Similarly it is also possible to create a table as follows.
1 | SQL> exec dbms_utility.exec_ddl_statement@DB_LINK('create table t1 (id number)'); |
In this way, it is possible to run DDL commands through the database link in the remote database.
