Home » SQL & PL/SQL » SQL & PL/SQL » Disable Trigger via DB Link
icon5.gif  Disable Trigger via DB Link [message #213285] Wed, 10 January 2007 03:30 Go to next message
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
Re: Disable Trigger via DB Link [message #213289 is a reply to message #213285] Wed, 10 January 2007 03:42 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
DDL is not allowed over a dblink.
Re: Disable Trigger via DB Link [message #213292 is a reply to message #213289] Wed, 10 January 2007 03:55 Go to previous messageGo to next message
petra69
Messages: 3
Registered: January 2007
Junior Member
Thanks for the information Frank
icon12.gif  Re: Disable Trigger via DB Link [message #215114 is a reply to message #213292] Fri, 19 January 2007 06:27 Go to previous messageGo to next message
oskarsdba
Messages: 7
Registered: January 2007
Location: Latvia
Junior Member
Hi,
you can via db link execute remote procedure which execute ddl statement.







Re: Disable Trigger via DB Link [message #215145 is a reply to message #215114] Fri, 19 January 2007 08:12 Go to previous message
petra69
Messages: 3
Registered: January 2007
Junior Member
Hallo Oskar,
a good Workaround. Thanks for the hint.
Petra
Previous Topic: Erratic Procedure behaviour
Next Topic: Convert a numeric value to INTERVAL YEAR in Oracle8i Enterprise Edition Release 8.
Goto Forum:
  


Current Time: Fri Dec 09 00:01:22 CST 2016

Total time taken to generate the page: 0.05498 seconds