Shrink SYSAUX tablespace in 10g?
Our SYSAUX tablespace is currently using a 32Gb of datafile, EM shows actual usage to be below 2Gb.
I've tried using the 'move' procedures from the sysaux_occupants view, tried moving tables and indexes individuallly, tried shrink and compact, etc. In all cases I cannot resize the datafile as I get the 'ORA-03297: file contains used data beyond requested RESIZE value'.
Has anyone come up with a successful method of shrinking SYSAUX?
Oracle Database 10g Release 10.2.0.3.0