RE: _sys_trig_enabled

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: