'ORA-20001: Invalid Or Inconsistent Input Values' During DBMS_STATS.GATHER_TABLE_STATS
(Doc ID 2448533.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
- While executing gather table stats for the table, following errors appear:
DBMS_STATS.GATHER_TABLE_STATS ( OWNNAME =>'USER_1', TABNAME =>'TAB_1', ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE, METHOD_OPT => 'FOR ALL COLUMNS SIZE AUTO', DEGREE => 4, GRANULARITY => 'ALL', CASCADE => TRUE, NO_INVALIDATE => FALSE, FORCE => TRUE );
Error:
ORA-20001 Invalid or inconsistent input values - Table is partitioned and has INCREMENTAL preference set tot TRUE
Changes
No changes.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |