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%';


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


-----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


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
"Zen is not easy.
It takes effort to attain nothingness.
And then what do you have?
Bupkes."  -- The Goddess


Other related posts: