RE: upgrade from 8 or 9 to 10g and SYSAUX
- From: <rajendra.pande@xxxxxxx>
- To: <lyallbarbour@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 Aug 2010 13:13:10 -0400
Lyall
I do not have access to ODM but going by other packages - look for
$OH/dm/admin directory and grep for move_odm in the files
For example for ultrasearch the procedure is MOVE_WK and it is in a file
called wk0plb.sql in $OH/ultrasearch/
And I am guessing that if everything is correctly installed you should
be able to see this in DBA_OBJECTS.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
lyallbarbour@xxxxxxxxxxxxxxx
Sent: Tuesday, August 31, 2010 9:53 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: upgrade from 8 or 9 to 10g and SYSAUX
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
Please visit our website at
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html
for important disclosures and information about our e-mail
policies. For your protection, please do not transmit orders
or instructions by e-mail or include account numbers, Social
Security numbers, credit card numbers, passwords, or other
personal information.
Other related posts:
