upgrade from 8 or 9 to 10g and SYSAUX

From: <lyallbarbour_at_sanfranmail.com>
Date: Tue, 31 Aug 2010 09:53:27 -0400
Message-Id: <8CD172B05C44EAF-13C4-1DDC_at_web-mmc-m10.sysops.aol.com>

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    

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 31 2010 - 08:53:27 CDT