RE: dbms_stats via dbms_job - syntax question SOLVED

2003-06-11 Thread Hallas, John, Tech Dev
Thanks for all the help. The problem was not with my coding but the syntax. In my worked example I had CASCADE=TRUE whereas it should have been CASCADE=TRUE. A subtle difference but one that caused me (and fellow listers) no end of hassle. So all the answers that I said were incorrect were

RE: dbms_stats via dbms_job - syntax question SOLVED

2003-06-11 Thread Igor Neyman
But one thing I proved was that you can mix and match positional and naming parameters Hmm, I'd still rather use one OR another: you never know if mixing them would work in the next version... Why trying your luck?-:) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Hallas,

RE: dbms_stats via dbms_job - syntax question SOLVED

2003-06-11 Thread DENNIS WILLIAMS
John Then be sure to set the init.ora parameter _do_what_I_mean=true It solved most of my problems. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 11, 2003 4:35 AM To: Multiple recipients of list ORACLE-L