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: rollback tablespace datafile too big

Re: rollback tablespace datafile too big

From: <oratune_at_aol.com>
Date: 2000/07/28
Message-ID: <8ls6v8$il0$1@nnrp1.deja.com>#1/1

In article <8ls0j2$df9$1_at_nnrp1.deja.com>,   fly13_at_my-deja.com wrote:
> Hi
> Here is a n easy question about RBS tablespace on Oracle 8.1.6.
> I had big transaction to do on a table.
> And so my RBS datafile (rbs1.dbf) is very big.
> The problem is when there is no transaction any more, and the commit
> has been done, the size of the RBS datafile is still the same.
> I try to coalesce this tablespace, but no result.
> Can someone help me to reduce the size of this file?
>
> Cheers in advance!!!
>
> Fly13
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Datafiles don't shrink when there is no data in them. Once you create a datafile you can't make it smaller without dropping the tablespace, deleting the datafile and then recreating the tablespace with a smaller datafile.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Jul 28 2000 - 00:00:00 CDT

Original text of this message

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