Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Combining freespace
export/import.
You might be able to avoid the pain in future by use of locally managed tablespaces but that is a version specific feature.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Vince Laurent" <vlaurent_at_NOSPAMPLEASE.networkusa.net> wrote in message news:d0t5busq0a2k6184lnnjid3nu0kudtm8iv_at_4ax.com...Received on Tue Apr 09 2002 - 09:33:19 CDT
> We have a tablespace that is giving us a warning that it will overflow
> if it grows. Here is the scoop:
>
> 'number of extents to tablespace overflow' [2] ==>
>
> SAPDBA: 2002-04-09 08.23.06 - Checking tablespace PSAPSTABD ...
>
> Total tablespace size : 664895 blocks / 5319160 K
> Total free space : 151808 blocks / 1214464 K
> Largest free space area : 7160 blocks / 57280 K
>
> All the tablespaces are coalesced. So how do I combine the 1.2G of
> free space so any of the tables can use it? Is there some SQL
> command that will do a 'defrag' of sorts?
>
> Thanks in advance...
> Vince