QL> EXEC dbms_stats.gather_table_stats(ownname => 'RADINFO ',tabname => upper('PACSFAILEDIMAGES'),degree=>3,cascade=>true,estimate_percent => 10,no_invalidate=>FALSE);
BEGIN dbms_stats.gather_table_stats(ownname => 'RADINFO ',tabname => upper('PACSFAILEDIMAGES'),degree=>3,cascade=>true,estimate_percent => 10,no_invalidate=>FALSE); END;
*
ERROR at line 1:
ORA-20000: Unable to analyze TABLE "RADINFO "."PACSFAILEDIMAGES", insufficient privileges or does
not exist
ORA-06512: at "SYS.DBMS_STATS", line 24270
ORA-06512: at "SYS.DBMS_STATS", line 24332
ORA-06512: at line 1
SQL> EXEC dbms_stats.gather_table_stats(ownname => 'RADINFO ',tabname => 'PACSFAILEDIMAGES',degree=>3,cascade=>true,estimate_percent => 10,no_invalidate=>FALSE);
BEGIN dbms_stats.gather_table_stats(ownname => 'RADINFO ',tabname => 'PACSFAILEDIMAGES',degree=>3,cascade=>true,estimate_percent => 10,no_invalidate=>FALSE); END;
*
ERROR at line 1:
ORA-20000: Unable to analyze TABLE "RADINFO "."PACSFAILEDIMAGES", insufficient privileges or does
not exist
ORA-06512: at "SYS.DBMS_STATS", line 24270
ORA-06512: at "SYS.DBMS_STATS", line 24332
ORA-06512: at line 1
SQL> EXEC dbms_stats.gather_table_stats(ownname => 'RADINFO',tabname => 'PACSFAILEDIMAGES',degree=>3,cascade=>true,estimate_percent => 10,no_invalidate=>FALSE);
BEGIN dbms_stats.gather_table_stats(ownname => 'RADINFO',tabname => 'PACSFAILEDIMAGES',degree=>3,cascade=>true,estimate_percent => 10,no_invalidate=>FALSE); END;
*
ERROR at line 1:
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "SYS.DBMS_STATS", line 24281
ORA-06512: at "SYS.DBMS_STATS", line 24332
ORA-06512: at line 1
SQL> exec dbms_stats.unlock_table_stats('RADINFO','PACSFAILEDIMAGES');
PL/SQL procedure successfully completed.
SQL> EXEC dbms_stats.gather_table_stats(ownname => 'RADINFO',tabname => 'PACSFAILEDIMAGES',degree=>3,cascade=>true,estimate_percent => 10,no_invalidate=>FALSE);
PL/SQL procedure successfully completed.
SQL> exec DBMS_STATS.UNLOCK_schema_STATS('RADINFO');
PL/SQL procedure successfully completed.
