RE: _sys_trig_enabled

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Mon, 14 Nov 2005 11:48:28 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF2705A4525B@AABO-EXCHANGE02.bos.il.pqe>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_at_gmail.com


------------------------------------------------------------------------

"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 Received on Mon Nov 14 2005 - 10:51:13 CST