Re: Who is using my datafile

From: Jared Still <>
Date: Thu, 10 Jul 2008 16:11:40 -0700
Message-ID: <>

On Tue, Jul 8, 2008 at 12:33 PM, Jared Still <> wrote:

> On Tue, Jul 8, 2008 at 10:09 AM, Yechiel Adar <>
> wrote:
> Objects have been created in the tablespace, increasing the file high water
> mark.
> Even after the objects have been dropped, the HWM remains.

That is apparently 'old knowledge'. IIRC it used to work that way. 8i perhaps? Sometimes it's difficult to remember what stuff to forget. :)

I was just playing with this again, as I need to do something similar here ( oops, we let our database grow to 800g, and now we only need 50g,   can you help? )

I ran the same tests in 9i, only this time the datafile could be shrunk to 512k after dropping the tables, which is how it should work.

If you can spot an error in the test scenario I provided in my previous post, please feel free to share it. I just look again, and still don't see the problem.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Thu Jul 10 2008 - 18:11:40 CDT

Original text of this message