Combining freespace

From: Vince Laurent <vlaurent_at_NOSPAMPLEASE.networkusa.net>
Date: Tue, 09 Apr 2002 09:03:05 -0500
Message-ID: <d0t5busq0a2k6184lnnjid3nu0kudtm8iv@4ax.com>

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 Received on Tue Apr 09 2002 - 09:03:05 CDT