Sql script does not work
Hi experts.
I have the following script that is not running.
EXECUTE 'BEGIN DBMS_STATS.GATHER_TABLE_STATS(
ownname => 'SYSADM'
,tabname => 'PSACCESSLOG'
,estimate_percent => NULL
,block_sample => FALSE
,method_opt => 'FOR ALL INDEXED COLUMNS'
,degree => DBMS_STATS.AUTO_DEGREE
,cascade => FALSE
);END;'
EXECUTE 'BEGIN DBMS_STATS.GATHER_TABLE_STATS(
ownname => 'SYSADM'
,tabname => 'PSAPMSGPUBCON'
,estimate_percent => NULL
,block_sample => FALSE
,method_opt => 'FOR ALL INDEXED COLUMNS'
,degree => DBMS_STATS.AUTO_DEGREE
,cascade => FALSE
);END;'
EXECUTE 'BEGIN DBMS_STATS.GATHER_TABLE_STATS(
ownname => 'SYSADM'
,tabname => 'PSAPMSGPUBERR'
,estimate_percent => NULL
,block_sample => FALSE
,method_opt => 'FOR ALL INDEXED COLUMNS'
,degree => DBMS_STATS.AUTO_DEGREE
I have the following script that is not running.
EXECUTE 'BEGIN DBMS_STATS.GATHER_TABLE_STATS(
ownname => 'SYSADM'
,tabname => 'PSACCESSLOG'
,estimate_percent => NULL
,block_sample => FALSE
,method_opt => 'FOR ALL INDEXED COLUMNS'
,degree => DBMS_STATS.AUTO_DEGREE
,cascade => FALSE
);END;'
EXECUTE 'BEGIN DBMS_STATS.GATHER_TABLE_STATS(
ownname => 'SYSADM'
,tabname => 'PSAPMSGPUBCON'
,estimate_percent => NULL
,block_sample => FALSE
,method_opt => 'FOR ALL INDEXED COLUMNS'
,degree => DBMS_STATS.AUTO_DEGREE
,cascade => FALSE
);END;'
EXECUTE 'BEGIN DBMS_STATS.GATHER_TABLE_STATS(
ownname => 'SYSADM'
,tabname => 'PSAPMSGPUBERR'
,estimate_percent => NULL
,block_sample => FALSE
,method_opt => 'FOR ALL INDEXED COLUMNS'
,degree => DBMS_STATS.AUTO_DEGREE
0