hey all,
Can someone take a look at this a tell me what my sins of commission or ommission are :confused:
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