ORA-01007: variable not in select list and ORA-06512: at "SYS.DBMS_STATS", line 15188
I have upgraded my database version from 10.2.0.4.3 to 10.2.0.5.7. After upgrade, i ran the gather schema as
exec dbms_stats.gather_schema_stats(ownname=>'PENTAISF',options=> 'GATHER',estimate_percent => 30,method_opt=> 'FOR ALL COLUMNS SIZE AUTO',cascade=> TRUE,degree=> 5)
This process took about 79 hours to complete. After completed, i ran another gather schema with ,method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY as
BEGIN dbms_stats.gather_schema_stats(ownname=>'PENTAISF',options=>'GATHER',estimate_percent => 30,method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY',cascade=>TRUE,degree=> 5); END;
this process took about 81:19:47.37 hours, but it prompt out error and this process terminated. The error is