Re: data file compact

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 10 Nov 2001 16:16:13 +0100
Message-ID: <tuqhjc537ah764@corp.supernews.com>

"ed zappulla" <zappullae_at_rcn.com> wrote in message news:9sjedu$c8j$1_at_bob.news.rcn.net...
> Is there a way to compact the data files that oracle 8.1.6 uses? They
seem
> to be growing very large while the amount of data an indexs held remains
the
> same.
>
>
>

There is no mechanism to 'compact' the datafiles, whatever you may mean by compacting.
Please check whether you have any tablespace(s) on autoextend. This must be the case otherwise datafiles wouldn't grow. Please also check how much of the allocated space is actually occupied. If you don't know how to do that please read the Oracle Server Administrators Manual.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Sat Nov 10 2001 - 09:16:13 CST