Unanswered: SYSAUX - change Segment space management
I'm in the middle of a migration from Oracle 9i to 10g under Linux.
After creating the new tablespace sysaux I realized there was a mistake.
It should have been created with Segment space management in "auto", and it was created in "manual".
As far a I know, it cannot be changed, but it can't also be dropped.
So, what can I do in ortder to go on with the installation ?
My idea was to move objects from SYSAUX to any other TS, drop sysaux and re-create it propperly. The problem is I can't drop it.