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: dbms_space_admin.segment_moveblocks procedure: purpose ?

Re: dbms_space_admin.segment_moveblocks procedure: purpose ?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 14 Mar 2007 18:48:51 +0100
Message-ID: <45f83581$0$26317$426a34cc@news.free.fr>

"DA Morgan" <damorgan_at_psoug.org> a écrit dans le message de news: 1173892122.718587_at_bubbleator.drizzle.com...
| Spendius wrote:
| > Hi,
| > This procedure is not documented. File $ORACLE_HOME/rdbms/admin/
| > dbmsspc.sql
| > says it "moves blocks from the segment header to the process
| > freelist": I'm not sure
| > I understand what that means. Someone ever used that procedure
| > before ? What does
| > it do ?
| > Thanks.
|
| All procedures in DBMS_SPACE_ADMIN have demos you can run at
| Morgan's Library (www.psoug.org).
| --
| Daniel A. Morgan
| University of Washington
| damorgan_at_x.washington.edu
| (replace x with u to respond)
| Puget Sound Oracle Users Group
| www.psoug.org

All procedures but this one. ;-)

A remark, this package was already available in 8i, your page says "First available 10.1".

Regards
Michel Cadot Received on Wed Mar 14 2007 - 12:48:51 CDT

Original text of this message

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