ORA-3217 signalled during: ALTER TABLESPACE TEMP COALESCE...

Hi,

We have got "ORA-3217 signalled during: ALTER TABLESPACE TEMP COALESCE..." error on oracle database version 19.10 (SunOS 5.11 sparc).

We have found it is related to sys job "space_management.coalesce_tablespaces;" with details below:

================

DECLARE

 user_name varchar2(30);

BEGIN

 select user into user_name from dual;

 execute immediate 'alter session set current_schema = SYS';

 BEGIN

  SYS.DBMS_JOB.REMOVE(34);

  execute immediate 'alter session set current_schema = ' || user_name ;

 EXCEPTION

  WHEN OTHERS THEN

   execute immediate 'alter session set current_schema = ' || user_name ;

   RAISE;

 END;

 COMMIT;

END;

/

DECLARE

 X NUMBER;

 user_name varchar2(30);

BEGIN

 select user into user_name from dual;