Re: free space

"Aaron D. Hager" <adhager_at_onebox.com> wrote in message news:8ogtpv$mf5$1_at_newsmaster.cc.columbia.edu...
> I have run out of space on my AIX system.
> I have dropped many tables, but the size of my data files remains the
 same.
> Is there any way to make the data files smaller?
> If I create new tables will it make my data files larger or will it reuse
> the area freed when I dropped the tables?
> Also what are the relatively large *.dbf files in \ora01\oradata\<SID>\ ?
>
> Any help will be greatly appreciated.
>
> Thanks,
>
> Aaron
>
>

To resize the datafiles
alter database datafile 'filename' resize ... M /

If you drop tables freed space will be reused, provided the free space is not heavily fragmented. You can coalesce the free space by issuing alter tablespace <tablespace_name > coalesce;

It is not possible to tell what the files are without the exact name. This is an OFA-compatible location for any file belonging to the database, you shouldn't delete them.
Use select file_name from dba_data_files and
select file_name from v$log_file
and
select file_name from v$control_file
to verify where you files are.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Aug 29 2000 - 13:55:30 CDT