RE: _sys_trig_enabled

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <shrekdba@xxxxxxxxx>, "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 14 Nov 2005 11:48:28 -0500

Hi Bill,

 SQL> select ksppinm from x$ksppi where ksppinm like '%trig%enabled%';

KSPPINM
----------------------------------------------------------------
_system_trig_enabled

Need to specify the correct parameter name....;-)

-Mark

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of bill thater
Sent: Monday, November 14, 2005 11:41 AM
To: Oracle Discussion List
Subject: _sys_trig_enabled

Oracle 9.2.0.4:

OK, I thought the syntax was:

alter system set "_sys_trig_enabled"=false;

but that ain't working.  so what did i mess up this time?;-)

--
--
Bill "Shrek" Thater     ORACLE DBA
       shrekdba@xxxxxxxxx
------------------------------------------------------------------------
"Zen is not easy.
It takes effort to attain nothingness.
And then what do you have?
Bupkes."  -- The Goddess
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Other related posts: