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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Combining freespace

Re: Combining freespace

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 9 Apr 2002 15:33:19 +0100
Message-ID: <3cb2fbb0$0$230$ed9e5944@reading.news.pipex.net>


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...

> 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:33:19 CDT

Original text of this message

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