I am trying to take the statistics as under but getting the following error:
1 begin
2 dbms_stats.gather_schema_stats(ownname=>'IPAO',
3 estimate_percent=>100,
4 block_sample=>true,
5 method_opt=>'for all columns size 1',
6 cascade=>true
7 );
8* end;
SQL> /
begin
*
ERROR at line 1:
ORA-20001: Illegal sample percent 100: must be in the range [0.000001,100)
ORA-06512: at "SYS.DBMS_STATS", line 7156
ORA-06512: at "SYS.DBMS_STATS", line 7594
ORA-06512: at "SYS.DBMS_STATS", line 7741
ORA-06512: at "SYS.DBMS_STATS", line 7789
ORA-06512: at "SYS.DBMS_STATS", line 7770
ORA-06512: at line 2