Re: LARGE database

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/07/26
Message-ID: <964644218.18075.1.pluto.d4ee154e@news.demon.nl>#1/1

From 7.3.4 onwards
alter database datafile '<datafilename>' resize ...M Please find the highest allocated extent (by block_id) using dba_extents first, or you will receive an error message

Hth,

Sybrand Bakker, Oracle DBA
<trafalco_at_my-deja.com> wrote in message news:8lnctg$18f$1_at_nnrp1.deja.com...
> We have a database that is 8 gigabytes in size. This is too big. There
> is hardly anything in it? We need to know how to decrease it's size to
> something normal! Please help us, thank you
>
> Tim
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jul 26 2000 - 00:00:00 CDT