exec DBMS_REGXDB.VALIDATEXDB returns ora-29903 ora-22881
Hi Community,
after cleaning up the SYSAUX-Tablespace I have a problem with XDB:
I'm running Oracle 19.6 on RedHat Linux 7.6.
I cleaned up the full SYSAUX-Tablespace with the following statements - I wanted to resize the datafile from 32G to 5G.
declare l_sql varchar2(4000); begin for tab in ( select owner, segment_name from dba_segments where tablespace_name = 'SYSAUX' and segment_type='TABLE' and partition_name is null order by 1, 2) loop begin l_sql := 'alter table ' || tab.owner || '."' || tab.segment_name || '" move'; dbms_output.put_line(l_sql); execute immediate l_sql; dbms_output.put_line('Erfolgreich reorganisiert'