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

rollback tablespace datafile too big

From: <fly13_at_my-deja.com>
Date: 2000/07/28
Message-ID: <8ls0j2$df9$1@nnrp1.deja.com>#1/1 






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.
Received on Fri Jul 28 2000 - 00:00:00 CDT












Original text of this message













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