OraFAQ Forum: SQL & PL/SQL » Disable Trigger via DB Link

Home » SQL & PL/SQL » SQL & PL/SQL » Disable Trigger via DB Link

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Disable Trigger via DB Link [message #213285]

Wed, 10 January 2007 03:30

petra69
Messages: 3
Registered: January 2007

Junior Member

Hallo,
ist it possible to diable a trigger via DB-Link?
If I try the following

ALTER TRIGGER <owner>.<Triggername>@<db-link> DISABLE;

I'm getting the follwing error:
ORA-0922 missing or invalid option

Can someone help mie?
Thanks in advance Petra

Report message to a moderator

Re: Disable Trigger via DB Link [message #213289 is a reply to message #213285]

Wed, 10 January 2007 03:42

Frank
Messages: 7901
Registered: March 2000

Senior Member

DDL is not allowed over a dblink.

Report message to a moderator

Re: Disable Trigger via DB Link [message #213292 is a reply to message #213289]

Wed, 10 January 2007 03:55

petra69
Messages: 3
Registered: January 2007

Junior Member

Thanks for the information Frank

Report message to a moderator

Re: Disable Trigger via DB Link [message #215114 is a reply to message #213292]

Fri, 19 January 2007 06:27

oskarsdba
Messages: 7
Registered: January 2007
Location: Latvia

Junior Member

Hi,
you can via db link execute remote procedure which execute ddl statement.

Report message to a moderator

Re: Disable Trigger via DB Link [message #215145 is a reply to message #215114]

Fri, 19 January 2007 08:12

petra69
Messages: 3
Registered: January 2007

Junior Member

Hallo Oskar,
a good Workaround. Thanks for the hint.
Petra

Report message to a moderator

Previous Topic:	Erratic Procedure behaviour
Next Topic:	Convert a numeric value to INTERVAL YEAR in Oracle8i Enterprise Edition Release 8.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 01:28:45 CST 2024