Re: How to shrink a database on Linux?

hi,

Some One Else wrote:
>
> Ok, I finally got Oracle 8.1.7 to install on Linux Mandrake 8. I used the
> Dbassist to create the database. At that time I had about 400 megs or more
> left on a 1.8 meg drive.
>
> Then I ran a thrasher test program. And it ate all my space creating the
> test table. So I dropped the test table. But Oracle hasn't relinquished the
> space it gobbled up. How do I get the database to shrink?
>
> If that's not possible, how do I safely delete the database without having
> to do another (12th ?) nightmarish install?
>
> Thanks everyone!

you can try an "alter database datafile '<name>' resize <size>;"

ciao
andreas

-- 
Andreas Necker

ISB AG              Tel: +49 (0)721/82800-0
Karlstrasse 52-54   Fax: +49 (0)721/82800-82
76133 Karlsruhe     mailto:Andreas.Necker_at_isb-ag.de
Germany             http://www.isb-ag.de