Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center