Unable to run Segment space advisor Manually in the 19c Database
Hi Team,
I am facing below error when I am running segment space advisory manually in the 19c database.
Please check below error and let me know if it has any workaround
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_ADVISOR", line 226
ORA-06512: at "SYS.PRVT_ADVISOR", line 3546
ORA-06512: at "SYS.PRVT_ADVISOR", line 932
ORA-06512: at "SYS.WRI$_ADV_OBJSPACE_TREND_T", line 1204
ORA-06512: at "SYS.WRI$_ADV_OBJSPACE_TREND_T", line 1870
ORA-06512: at "SYS.PRVT_ADVISOR", line 915
ORA-06512: at "SYS.PRVT_ADVISOR", line 3451
ORA-06512: at "SYS.DBMS_ADVISOR", line 276
ORA-06512: at "SYS.DBMS_ADVISOR", line 221