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: FYI: script to resize datafiles before backup

Re: FYI: script to resize datafiles before backup

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Wed, 13 Feb 2002 22:10:19 GMT
Message-ID: <3c6ae354.769863@news.freeler.nl> 





The last block actually is max(a.block_id + a.blocks - 1)



For example, if your block_id of the highest extent = 100 and blocks =
3, the extent contains block_id 100, 101 and 102.



Jaap.



On Wed, 13 Feb 2002 17:45:38 +0100, "Andre van Winssen \(andrew\)"
<andrew-no-spam-svp_at_info.nl> wrote:



> ...


>                      max(a.block_id + a.blocks + 1) last_block




> ...

Received on Wed Feb 13 2002 - 16:10:19 CST












Original text of this message













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