Consider switching to autoextend. It is scary I know. Won't work in
every environment. But it can achieve your goals with less effort. Today if
a tablespace is nearly full, what do you do? Go tell the users to delete
some data? Nah, you probably just increase the size of the tablespace and go
back to sleep. If there are 10 tablespaces on a device, you have 10 failure
points. Autoextend can reduce that to a single failure point. It is easier
and more reliable to monitor a single point of failure. Only autoextend data
and index tablespaces, not undo or temp tablespaces.

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html---------------------------------------------------------------------------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org