Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_SPACE_ADMIN, 12 of 13
Use this procedure to relocate the bitmaps to the destination specified. Migration of a tablespace from dictionary managed to locally managed format could result in the creation of SPACE HEADER segment that contains the bitmap blocks. The SPACE HEADER segment is treated as user data. If the user wishes to explicitly resize a file at or below the space header segment, an error is issued. Use tablespace_relocate_bitmaps command to move the control information to a different destination and then resize the file.
TABLESPACE_RELOCATE_BITMAPS (Tablespace_Name, Relative_fno, Block_Number)
The tablespace must be kept online and read write during relocation of bitmaps. Can be done only on migrated locally managed tablespaces.
execute dbms_space_admin.tablespace_relocate_bitmaps('TS1', 3, 4);
Moves the bitmaps to file 3, block 4.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|