Re: Unix file system full

relax no problem u can create new files with respect to the tablepsace on a different partition so now if you create more tables then it will use that file and then make the autoextend feature of for all the other files which are with respect to the tablespace. I hope all the partitions of your file system are not full.
create new files with respect to your temporary tablespace too

Alex Hudghton wrote:

> 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 - 05:54:51 CST