Re: datafile problem

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 26 Aug 2002 19:30:07 GMT
Message-ID: <3d6a817a.1489236468@news.globix.com>

use view DBA_FREE_SPACE and DBA_SEGMENTS to determine whether you have enough space or if you're going to run out soon.

e.g.

SELECT rpad(OWNER||'.'||SEGMENT_NAME,40)||rpad('want: '||NEXT_EXTENT/1024||'k',16)||
rpad('in: '||S.TABLESPACE_NAME, 23),rpad('avail: '||MAX_FREE_BYTES/1024||'k',16)
 FROM SYS.DBA_SEGMENTS S,
    (SELECT TABLESPACE_NAME,MAX(BYTES) MAX_FREE_BYTES

     FROM SYS.DBA_FREE_SPACE
     GROUP BY TABLESPACE_NAME) F

 WHERE S.NEXT_EXTENT > F.MAX_FREE_BYTES
  AND S.TABLESPACE_NAME=F.TABLESPACE_NAME   AND S.TABLESPACE_NAME NOT LIKE '%RBS%'"); On 26 Aug 2002 12:02:21 -0700, hmatijaca_at_yahoo.ca (Helena) wrote:

>Thank you for your help
>I have increased the size of the datafile, since this is a production database
>I don't know if is correct but I'm trying to get more help
>
>"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:<U3ra9.11477$zX3.19308_at_news.indigo.ie>...
>> One presumes that an undesirable answer is "Drop all the tables in it. "
>> (this is an answer portable between versions of Oracle tho.)
>>
>> however, pls post version of Oracle; there are different possible answers.
>>
>>
>> "Helena" <hmatijaca_at_yahoo.ca> wrote in message
>> news:c5a36d06.0208260634.47c52694_at_posting.google.com...
>> > I have a production db in which I have incresed a tablesplace and the
>> > datafile it shows at 99% full, but I do have lots of space on the
>> > tablespace, How can I clean the datafiel to show empty?

.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email Received on Mon Aug 26 2002 - 14:30:07 CDT