oracle通过DBLINK执行DDL

问了个其它世界的网友，终于发现还是可以的，当然如果ORACLE官方的资料读的足够多，你也知道的。
现在把网友的答复复制到下文：

Subject: Re: how to create procedure by using dblink	Author: Michel Cadot	Date: Mon, 27 June 2011 18:07
You can do it as you can call a remote procedure: SQL> select  * from t@mika;         ID ----------          0   1 row selected.   SQL> exec dbms_utility.EXEC_DDL_STATEMENT@mika('drop table t')   PL/SQL procedure successfully completed.   SQL> select  * from t@mika; select  * from t@mika                * ERROR at line 1: ORA-00942: table or view does not exist   SQL> exec  dbms_utility.EXEC_DDL_STATEMENT@mika('create or replace procedure p is begin dbms_output.put_line(''YES''); end;')   PL/SQL procedure successfully completed.   SQL> exec p@mika YES   PL/SQL procedure successfully completed.

转载自:http://lzfhope.blog.163.com/blog/static/636399220115285120540/