TABLESPACE_RELOCATE_BITMAPS Procedure

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.

Syntax

TABLESPACE_RELOCATE_BITMAPS (Tablespace_Name, Relative_fno, Block_Number)

Parameters

Table 61-12 Parameters for TABLESPACE_RELOCATE_BITMAPS

Parameter Name	Purpose	Datatype	Parameter Type
Tablespace_Name	Name of Tablespace.	VARCHAR	IN
RFNO	Relative File Number of the destination file.	NUMBER	IN
BLKNO	Block Number of the destination dba.	NUMBER	IN

Usage Notes

The tablespace must be kept online and read write during relocation of bitmaps. Can be done only on migrated locally managed tablespaces.

Example

execute  dbms_space_admin.tablespace_relocate_bitmaps('TS1', 3, 4);

Moves the bitmaps to file 3, block 4.

Note: The source and the destination addresses should not overlap. The destination block number is rounded down to the unit boundary. If there is user data in that location an error is raised.