upgrade from 8 or 9 to 10g and SYSAUX
- From: lyallbarbour@xxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 31 Aug 2010 09:53:27 -0400
Hello everyone,
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...
Lyall
Other related posts:
