Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYSAUX
co4770_at_yahoo.com wrote:
> On Aug 13, 11:20 am, Terminator <kramakrishnab..._at_gmail.com> wrote:
If your motive is "to save space" find something else to do with your free time. You are dangerously close to trashing a database.
It won't save enough space to compensate for the amount of hard disk an hour of your salary would buy.
This is a bad idea in every sense of the word because you are not allowed to move the contents of SYSAUX except as specifically provided for by Oracle.
set linesize 121
col occupant_name format a40
col move_procedure format a40
select occupant_name, move_procedure
from gv$sysaux_occupants;
Note that many do not have a move procedure. There is a reason.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Aug 13 2007 - 10:29:45 CDT
![]() |
![]() |