Stephen, Did you write all the parameters by hand or used a script? ;)
> "analyze table ...." have "exec DBMS_STATS.ONE_OF_273_POSSIBLE_CALLS(arg1, > arg2, arg3, arg4, arg5, arg6, arg7, arg8, arg9, arg10, arg11, arg12, arg13, > arg14, arg15, arg16, arg17, arg18, arg19, arg20, arg21, arg22, arg23, arg24, > arg25, arg26, arg27, arg28, arg29, arg30, arg31, arg32, arg33, arg34, arg35, > arg36, arg37, arg38, arg39, arg40, arg41, arg42, arg43, arg44, arg45, arg46, > arg47, arg48, arg49, arg50, arg51, arg52, arg53, arg54, arg55, arg56, arg57, > arg58, arg59, arg60, arg61, arg62, arg63, arg64, arg65, arg66, arg67, arg68, > arg69, arg70, arg71, arg72, arg73, arg74, arg75, arg76, arg77, arg78, arg79, > arg80, arg81, arg82, arg83, arg84, arg85, arg86, arg87, arg88, arg89, arg90, > arg91, arg92, arg93, arg94, arg95, arg96, arg97, arg98, arg99, arg100)". > > Do you get the impression that Oracle is just too damn lazy to update their > syntax parser? I don't see anything wrong with it - I thank god (every night) that Oracle has so many features and controls and hasn't hidden them away from us. If you want to do things easy - use OEM and get SQL & PL/SQL execution commands from it using "Show SQL". Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).