Manipulation with object end with ORA-08104
Hello, I am trying to reorganize SYSAUX objects.
SQL> alter table PLSCOPE_ACTION$ move;
alter table PLSCOPE_ACTION$ move
*
ERROR at line 1:
ORA-08104: this index object 6495709 is being online built or rebuilt
SQL> declare
msd BOOLEAN;
begin
msd := dbms_repair.online_index_clean(6495709);
end;
/ 2 3 4 5 6 7 8 9 10 11
declare
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-12801: error signaled in parallel query server P000
ORA-04021: timeout occurred while waiting to lock object SYS.PLSCOPE_ACTION$
ORA-06512: at "SYS.DBMS_REPAIR", line 476
ORA-06512: at line 7
I was trying the above procedure yet it also throws an error. When querying for the session using the object none will show. What can be done? DB ver is 19.20 running on RHEL 7 VM.