Stephen - To quote Monty Python "And now for something completely different
. . .
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.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Wales, Stephen (RTSI)
Sent: Tuesday, June 22, 2004 11:34 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Next Extent Failure Notification for Locally Managed
Tablespaces
That's not overly helpful, no ;)
I don't suppose there's any way to modify a tablespace to use uniform =
extents after creation is there? It doesn't look like it, but if there =
is, I figured I'd ask.
I really don't have the luxury of recreating this database.
Steve
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Niall Litchfield
Sent: Tuesday, June 22, 2004 2:17 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Next Extent Failure Notification for Locally Managed
Tablespaces
It probably doesn't help to point out that you can avoid this effort
entirely with uniform extents does it?
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------