upgrade from 8 or 9 to 10g and SYSAUX
Date: Tue, 31 Aug 2010 09:53:27 -0400
Who out there has done any flavour of the above upgrade and also moved some of the options to the SYSAUX tablespace. Metalink note 243246.1 talks about it, but i am missing something. I'd like to move ODM out of ODM tablespace to SYSAUX and drop the ODM tablespace. The note says:
Transfer occupants from/to SYSAUX to/from another tablespace
6.1 If an occupant of the tablespace SYSAUX takes too much space, you can
move it to another tablespace. Similarly, a valid schema can be transferred back to SYSAUX tablespace. See steps below.
6.2 Find the right procedure to perform the transfer :
SQL> SELECT occupant_name, schema_name, move_procedure, space_usage_kbytes FROM v$sysaux_occupants ORDER BY 1; ODM DMSYS MOVE_ODM 0
What is this MOVE_ODM and how do i use it? i don't get it...
LyallReceived on Tue Aug 31 2010 - 08:53:27 CDT