Re: DDL over DBLINK

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sun, 25 Dec 2005 22:55:21 +0100
Message-ID: <don4g5$ek3$01$1@news.t-online.com>

Jack schrieb:
> 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
>

AFAIK it is disallowed to do any ddl over dblink. The workaround may be to put ddl into a job queue on the remote side.

Best regards

Maxim Received on Sun Dec 25 2005 - 15:55:21 CST

This message: [ Message body ]
Next message: Scarab: "Re: Batch insert data into oracle from text file."
Previous message: Mladen Gogala: "Re: Nice present, only discovered for Christmas"
In reply to: Jack: "DDL over DBLINK"
Next in thread: yong321_at_yahoo.com: "Re: DDL over DBLINK"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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