DB Link [message #436180] |
Tue, 22 December 2009 00:54 |
prakashaa
Messages: 31 Registered: November 2009 Location: Bangalore
|
Member |
|
|
Can we perform DDL operations through Database Link.
If can what are those.
|
|
|
|
|
Re: DB Link [message #436200 is a reply to message #436180] |
Tue, 22 December 2009 01:39 |
|
Michel Cadot
Messages: 68704 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Execute the remote dbms_utilitty.exec_ddl_statement.
SQL> exec dbms_utility.exec_ddl_statement@<db link>('create table z (col integer)')
PL/SQL procedure successfully completed.
SQL> select * from z@<db link>;
no rows selected
(I removed the db link name for confidentiality)
Regards
Michel
|
|
|