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: RMAN - size of backup set

Re: RMAN - size of backup set

From: sybrandb <sybrandb_at_gmail.com>
Date: 19 Sep 2006 06:45:51 -0700
Message-ID: <1158673551.458947.118720@k70g2000cwa.googlegroups.com> 






Andy Kent wrote:


> >upgrade to 10g

>

> This is scheduled, but we have to deal with 8.1.7 for the next six

> months or so.

>

> Solution anyone please?




alter table foo move tablespace bar (or any other reorganizational
process or tool)


followed by


alter database datafile '/u01/oradata/blah/blah01.dbf' resize <some
really small value>



Who said that reorganizations weren't useful ;)


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Tue Sep 19 2006 - 08:45:51 CDT












Original text of this message













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