Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DDL over DBLINK

Re: DDL over DBLINK

From: <yong321_at_yahoo.com>
Date: 27 Dec 2005 20:57:26 -0800
Message-ID: <1135745846.866175.312410@g14g2000cwa.googlegroups.com>


Jack wrote:
> Hi,
> Can we do DDL over DBLink ?
> Like alter table exchange partition or trucate table over a dblink.
> I am using oracle 8.1.

Try dbms_sql. An example is at

https://metalink.oracle.com/metalink/plsql/f?p=200:27:1553940616056295572::::p27_id,p27_show_header,p27_show_help:80893.998,1,1

Yong Huang Received on Tue Dec 27 2005 - 22:57:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US