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: free space

Re: free space

From: Mark D Powell <markp7832_at_my-deja.com>
Date: Tue, 29 Aug 2000 18:59:53 GMT
Message-ID: <8oh16s$ulr$1@nnrp1.deja.com>

In article <8ogtpv$mf5$1_at_newsmaster.cc.columbia.edu>,   "Aaron D. Hager" <adhager_at_onebox.com> wrote:
> 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
>

Files that end in .dbf are normally database data files, i.e., these are probably the files that make up the tablespaces.

Deleting Oracle objects has no direct effect on the size of the datafiles used to hold the object. Whether or not you can shrink a file depends on how the file is defined, extendible or not. See the DBA Admin manual and the SQL manual.

Look for *.trc, trace, files and core files under the $ORACLE_HOME directory as these can be deleted. Also the sqlnet and listener .log files can be removed. Before removing the listener.log file make sure you turn logging off in the listener or the remove command will look like it worked but UNIX does not release the file until the listerner closes it.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Aug 29 2000 - 13:59:53 CDT

Original text of this message

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