Re: Tablespace Question

From: Michael Krolewski <vandra_at_u.washington.edu>
Date: Sat, 20 Mar 1999 01:47:25 -0800
Message-ID: <36F36EAD.40939B61@u.washington.edu>

The Oracle Administration tool can give you information on the number of extents, etc for the database.

Since Oracle currently support near infinite extents for a given table, generally one would presume that the tablespace is out of space. Of course, it is possible that the tablespace has space but there is largest available extent is smaller than the requested extent. If one allows the extents to grow with each additional extent (default behaviour), it is possible to be asking for a lot of space when extending a table.

The manual has information on determining available extents, etc.

Mike Krolewski

Arthur Merar wrote:

> Hello,
>
> When you get a message about a table or tablespace that cannot be
> extended or has no more room, how can you tell whether it is the table
> or tablespace? And, what is the best way to deal with it?
>
> Thanks,
>
> Arthur
> amerar_at_unsu.com
Received on Sat Mar 20 1999 - 03:47:25 CST