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: Help needed-- free space in tables

Re: Help needed-- free space in tables

From: Sean Fitzgerald <sfitzgerald_at_centuryinter.net>
Date: Mon, 17 May 1999 22:16:29 -0400
Message-ID: <W6403.12670$_m5.2268573@newsread1-mx.centuryinter.net>


dba_free_space will only show the free space in a tablespace not a table for a table you need to do some more in depth work -- you can't just query the data from a view or table.
tedchyn_at_yahoo.com wrote in message <7hpo6d$rle$1_at_nnrp1.deja.com>...
>vick, you are able to find out from dba_free_spce. Ted
>In article <7hpde0$jed$1_at_nnrp1.deja.com>,
> newbie DBA <vramming_at_my-dejanews.com> wrote:
>> I need to find out how much free space in left in some tables or if I
>> should increase the values of MAX_EXTENTS and PCTINCREASE.
>> Help greatly appreciated!
>> Thanks
>> Vick
>>
>> --== Sent via Deja.com http://www.deja.com/ ==--
>> ---Share what you know. Learn what you don't.---
>>
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Mon May 17 1999 - 21:16:29 CDT

Original text of this message

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