drop/recreate awr repository to reclaim space.
It still seems that the AWR repository is using almost 10G of space(as seen from the V$sysaux_occupants table).
OCCUPANT_NAME Space (M)
---------------------------------------------------------------- -----------
SCHEMA_NAME
----------------------------------------------------------------
MOVE_PROCEDURE
----------------------------------------------------------------
SYS
SM/AWR 9,828.00
SYS
At this point I would be very happy to just drop and recreate the repository. I have found conflicting information on how to do this. All sources seem to say to run @?/rdbms/admin/catnoawr.sql to drop it, but to recreate one source says to run @?/rdbms/admin/catsvrm.sql and one says to run catawrtb.sql. I notice that the first script calls the second and does a lot more. Can someone tell me how to do this..