Analyze tables by loop

[ndisang]

hey all,
Can someone take a look at this a tell me what my sins of commission or ommission are

Thanks

SQL> begin
for rec in (select table_name from user_tables where TRUNC(last_analyzed) =('20-DEC-2004')
loop
dbms_stats.gather_table_stats(tabname => rec.table_name, degree =>2, estimate_percent => 5, cascade => true);
end loop;
end;
/
dbms_stats.gather_table_stats(tabname => rec.table_name, degree =>2, estimate_percent => 5, cascade => true);
*
ERROR at line 4:
ORA-06550: line 2, column 91:
PL/SQL: ORA-00933: SQL command not properly ended
ORA-06550: line 2, column 12:
PL/SQL: SQL Statement ignored
ORA-06550: line 4, column 109:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
loop

[slimdave]

Line 2 is missing a closing paren. also don't rely on the date format ... use a to_date() and a format picture on the date literal.

[ndisang]

Line 2 is missing a closing paren. also don't rely on the date format ... use a to_date() and a format picture on the date literal.

Thanks a bundle....

[tamilselvan]

Plus, OWNNAME is missing in DBMS_STATS.GATHER_TABLE_STATS proc.

Tamil

[ndisang]

Plus, OWNNAME is missing in DBMS_STATS.GATHER_TABLE_STATS proc.

Tamil

thanks all
But I thought since I was going as the table owner (user_tables) I do not need the ownname?

[tamilselvan]

thanks all
But I thought since I was going as the table owner (user_tables) I do not need the ownname?

See if you get an error, w/o OWNNAME.

Tamil

[ndisang]

See if you get an error, w/o OWNNAME.

Tamil

Sure, it needed the ownname......thanks again...