XML Database (MOSC)

MOSC Banner

exec DBMS_REGXDB.VALIDATEXDB returns ora-29903 ora-22881

edited Sep 8, 2020 5:04AM in XML Database (MOSC) 1 commentAnswered

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'

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