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: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Sun, 25 Dec 2005 11:39:58 -0800
Message-ID: <if-dnQFZoOjraDPenZ2dnUVZ_tSdnZ2d@comcast.com>

"Jack" <amitkr.3_at_gmail.com> wrote in message news:1135538631.027435.306850_at_z14g2000cwz.googlegroups.com...
> Hi,
> Can we do DDL over DBLink ?
> Like alter table exchange partition or trucate table over a dblink.
> I am using oracle 8.1.
>
> If not is there any workaround.
>
> Thanks
>

Try creating a stored proc on the other end and then call that. Jim Received on Sun Dec 25 2005 - 13:39:58 CST

Original text of this message

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