RECOVER TABLE OWNER.TABLE_NAME to DATAPUMP gives error at recompilation/revalidation of SYS.KU$_TT
Greetings i run below script on rman so it will restore recover table on specific point on time as below
RUN {
RECOVER TABLE OWNER.TABLE_NAME
until time "to_date('08-aug-2024 00:00', 'dd-mon-yyyy hh24:mi')"
AUXILIARY DESTINATION '/u01/app/odaorahome/EXP/DATARESTORE'
DATAPUMP DESTINATION '/u01/app/odaorahome/EXP'
DUMP FILE 'TABLE_EXP.dmp'
NOTABLEIMPORT;
}
but i got below error
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/13/2024 18:31:59
RMAN-06136: Oracle error from auxiliary database: ORA-04045: errors during recompilation/revalidation of SYS.KU$_TTS_TAB_TABLESPACE_VIEW
ORA-16000: database or pluggable database open for read-only access