Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_SPACE_ADMIN, 7 of 13
This procedure marks the appropriate DBA range (extent) as free or used in bitmap.
DBMS_SPACE_ADMIN.TABLESPACE_FIX_BITMAPS ( tablespace_name IN VARCHAR2, dbarange_relative_file IN POSITIVE, dbarange_begin_block IN POSITIVE, dbarange_end_block IN POSITIVE, fix_option IN POSITIVE);
The following example marks bits for 50 blocks for relative file number 4, beginning at block number 33 and ending at 83, as USED
in bitmaps.
EXECUTE DBMS_SPACE_ADMIN.TABLESPACE_FIX_BITMAPS('USERS', 4, 33, 83, 7);
Alternately, specifying an option of 8 marks the bits FREE
in bitmaps. The BEGIN
and END
blocks should be in extent boundary and should be extent multiple. Otherwise, an error is raised.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|