ERROR in statistic devdta
Hi,
please I need help with statistic, ..I want submit this statement but I don't know the error resolution...
owner: devdta
--STATS OWNER
exec dbms_stats.GATHER_SCHEMA_STATS(ownname =>'DEVDTA', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, cascade => true,
method_opt => 'FOR ALL COLUMNS SIZE AUTO');
error:
Error starting at line 2 in command:
exec dbms_stats.GATHER_SCHEMA_STATS(ownname =>'DEVDTA', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, cascade => true,
Error report:
ORA-06550: line 1, column 124:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
0