Oralce DDL on Remote Database With Database Link

Oralce DDL Command on Remote Database With Database Link

 

원격지db DBLINK DDL 실행

 

exec dbms_utility.exec_ddl_statement@dblink('truncate table tb_test');

exec dbms_utility.exec_ddl_statement@dblink('create table tb_test(id number)');

exec dbms_utility.exec_ddl_statement@dblink('drop table tb_test');