We will like to start shrinking our Sysaux tablespace (data file) due to the ever extending of this tablespace.
Note: I know that going forward, I can make this tablespace not extendable in order to control the size. But currently, we need to write a script that will shrink or resize periodically.
First, I need to know if this is a good idea. (Please note that I read the Oracle documentation and they don't recommand it) and.
Second, what is the best scripted syntax to shrink such tablespace.
I will like to use the syntax
ALTER DATABASE DATAFILE 'h/home/ORACLE/ORADATA/MYDBF/sysaux01.DBF' RESIZE 100 K;
Edited by: Albert Zaza on Sep 17, 2010 11:47 AM