Automatic datafile creation with conditions?
- From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Mar 2009 09:05:18 -0500
We'd like to automatically add datafiles as tablespaces near full,
however we would only like to add a single datafile per tablespace; if
more space is required after that, we want to be notified and manually
add them.
Has anyone set something like this up? Automating the addition of
datafiles seems rather trivial (cron or OEM), it's the 'IF' condition
and what the best tool would be to accomplish this that is a challenge.
We're on 10gR2/Solaris 64 if that's relevant.
Chris Newman
Database Specialist
AITS, University of Illinois
217-333-5429
--
//www.freelists.org/webpage/oracle-l
Other related posts: