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

Home -> Community -> Usenet -> c.d.o.server -> Re: freespace in tablespace

Re: freespace in tablespace

From: JHY <jhy_at_earthling.net>
Date: Mon, 29 Jun 1998 21:30:20 -0400
Message-ID: <6n9f34$dpg@bgtnsc01.worldnet.att.net>


If you run out of freespace when you know there is free space your free space might be fragmented. Happens a lot with temp tablespaces. Try ALTER TABLESPACE tablespace COALESCE.

Ed Lufker wrote:

> Hi All:
>
> What is a tablespaces problem when it is always running out of
> free space????
>
> thanks in advance for any help
> eddie lufker
Received on Mon Jun 29 1998 - 20:30:20 CDT

Original text of this message

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