Error ORA-1008 While Collecting Table Statistics on Partition Table (Doc ID 2424717.1)

Last updated on AUGUST 04, 2018

Applies to:

Symptoms

• DBMS_STATS.GATHER_TABLE_STATS error ORA-01008:
  
  SQL> begin
  D 2 BMS_STATS.GATHER_TABLE_STATS(
    3 ownname => '<OWNER>'
    4 ,tabname => '<TABLE_NAME>'
    5 ,degree => 6
    6 , cascade => true
    7 ,no_invalidate => true
    8 ,force => TRUE
    9 );
   10 end;
   11 /
  begin
  *
  ERROR at line 1:
  ORA-01008: not all variables bound
  ORA-06512: at "SYS.DBMS_STATS", line 36873
  ORA-06512: at "SYS.DBMS_STATS", line 36507
  ORA-06512: at "SYS.DBMS_STATS", line 35428
  ORA-06512: at "SYS.DBMS_STATS", line 34760
  ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 7914
  ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 8170
  ORA-06512: at "SYS.DBMS_STATS", line 34581
  ORA-06512: at "SYS.DBMS_STATS", line 35168
  ORA-06512: at "SYS.DBMS_STATS", line 36230
  ORA-06512: at "SYS.DBMS_STATS", line 36716
  ORA-06512: at line 2
  
   
  
  

Changes

Cause