Re: Unix file system full

From: Alex Hudghton <alex_at_alenda.NOSPAM!.freeserve.co.uk>
Date: Thu, 10 Feb 2000 10:29:37 GMT
Message-ID: <38a29149.5077491@news.freeserve.net>

Did you have autoextend switched on on the datafiles ?

You may be able to shrink the datafiles back with

'Alter database datafile 'filename' resize <size> M'

This depends on where the data is located in the datafile. Otherwise I think you need to export / import after recreating the tablespace at a smaller size.

Do you need the space for something else ? Because there is no problem in running with the filesystem at 100%, unless it clashes with monitors you have in place :-)

Regards

Alex

On Wed, 9 Feb 2000 00:29:24 -0500, "Kevin Simon" <ksimon_at_fwi.com> wrote:

>I had a runaway task which created a whole bunch of tables and filled up a
>unix file system. I since dropped the tables, but my file system is still
>full.
>
>What do I have to do to retrieve the space?
>
>HP-UX 10.20, Oracle 8.04
>
>TIA
>Kevin
>
>
Received on Thu Feb 10 2000 - 04:29:37 CST