Re: Anyone got a simple script to detect full tables?

Define "full". Do you mean tables that have reached (or approaching) max extents? Do you mean tables that would cause failures if they grab another extent because they would deplete the tablespace? Oracle really doesn't have any concept such as a full table. You really can't say that a table can only have a certain number or rows. With unlimited extents on a table and auto extend on the tablespace then you have to start looking at the file systems where the data files reside. Beyond that, you would also have to examine any indexes to see if they are up against a limit on extents or space.

So, by definition the possability of a "simple" script existing is essentially nil.

Ken

Andy Hardy wrote:

> Hi,
>
> Have you got a simple script that can be run against a database that
> highlights those tables that are either currently full (and probably
> causing insert failures) or getting close to full?
>
> Andy
> --
> Andy Hardy. PGP key available on request
> ===============================================================
Received on Thu Jul 08 1999 - 09:16:29 CDT