Home » SQL & PL/SQL » SQL & PL/SQL » DB Link (oracle 9i)
DB Link [message #436180] Tue, 22 December 2009 00:54 Go to next message
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 #436186 is a reply to message #436180] Tue, 22 December 2009 01:10 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Just try it out and see what happens Smile
Also share your experience with us.

regards,
Delna
Re: DB Link [message #436187 is a reply to message #436180] Tue, 22 December 2009 01:10 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
ORA-02021:

sriram Smile
Re: DB Link [message #436200 is a reply to message #436180] Tue, 22 December 2009 01:39 Go to previous message
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
Previous Topic: Convert from Georgian Date(English Date) To Arabic Hijri Date
Next Topic: Difference between explicit cursors and ref cursor
Goto Forum:
  


Current Time: Mon Nov 04 12:40:13 CST 2024