RE: _system_trig_enabled=false - URGENT

2002-01-18 Thread Sherman, Paul R.
Of course, had you looked at the script before you executed it, and then made sure that you understood what it was doing, you would never have given yourself such a fright. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED]

RE: _system_trig_enabled=false - URGENT

2002-01-18 Thread Miller, Jay
Thanks! This gives the correct information. I guess I'm inclined to trust anything from ixora blindly :) Jay Miller -Original Message- Sent: Friday, January 18, 2002 4:56 PM To: Multiple recipients of list ORACLE-L You are not reading the value. Try this: select a.INDX NUM, a.KSP

RE: _system_trig_enabled=false - URGENT

2002-01-18 Thread Khedr, Waleed
You are not reading the value. Try this: select a.INDX NUM, a.KSPPINM NAME, a.KSPPITY TYPE, a.KSPPDESC DESCRIPTION, b.KSPPSTVL VALUE, b.KSPPSTDF ISDEFAULT from sys.X_$KSPPI a, sys.X_$KSPPCV b where a.indx = b.indx and a.ksppinm like '%trig%' order by 2 -Original Message-