Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Next Extent Failure Notification for Locally Managed Tablespaces

Re: Next Extent Failure Notification for Locally Managed Tablespaces

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 23 Jun 2004 14:38:09 +0100
Message-ID: <7765c897040623063861321643@mail.gmail.com>


On Wed, 23 Jun 2004 09:04:58 -0400, Kline.Michael <michael.kline_at_suntrust.com> wrote:
> Curious thing was it took a long time to truncate the old tables, and
> they were LOCAL, but there was a whole lot of the fet$ stuff, at least I
> think that was it going on during the clean up. But given the old 64K
> and the 30-50GB table sizes, there would have been a boat load of
> extents.

It is quite possible that you are seeing the effect of quotas which are still stored in the dictionary? I'm also not sure what happens if the tablespace were created by the dbms_space_admin.migrate_XXXX procedures.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
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
-----------------------------------------------------------------
Received on Wed Jun 23 2004 - 08:35:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US