Recently I faced the below error, while exporting & importing schema stats from Prod - Uat database. SQL> BEGIN dbms_stats.import_schema_stats ('TESTU','TESTP_STATS'); END; * ERROR at line 1: ORA-20000: Unable to set values for column TEST_COLUMN: does not exist or insufficient privileges ORA-06512: at "SYS.DBMS_STATS", line 7346 ORA-06512: at "SYS.DBMS_STATS", line 7373 ORA-06512: at "SYS.DBMS_STATS", line 8038 ORA-06512: at line 1 SOLUTION: 1. First I have tried giving the ANALYZE permission to the user. GRANT ANALYZE ANY TO "SYSTEM"; But after giving the above permission, still that issue is not resloved. 2. Now I have tried deleting that column from the temporary stats table. Which will create as part of export & import stats. SQL> desc testp_stats; Name Null? Type -------------...