how to create dbms_stast.gather_table_stats script

hey ng,

i want to create a script which creates a script with all tables. thats the way it looks at the moment:

spool dbmsstats_all.sql

SELECT 'EXECUTE DBMS_STATS.GATHER_TABLE_STATS(ownname=>upper(''AZUBI''),' || table_name || ');' FROM user_tables;

spool off

@dbmsstats_all.sql

but it isn't working. thats the error message:

ORA-06550: Zeile 1, Spalte 61:
PLS-00357: Table-, View- oder Sequence-Referenz 'SV_BEZEICHNUNG' in diesem Kontext nicht g³ltig
ORA-06550: Zeile 1, Spalte 7:
PL/SQL: Statement ignored

thanks for your help

max Received on Fri Aug 23 2002 - 02:12:01 CDT