TABLESPACE_FIX_SEGMENT_STATES Procedure

Use this procedure to fix the state of the segments in a tablespace in which migration was aborted. During tablespace migration to or from local, the segments are put in a transient state. If migration is aborted, the segment states are corrected by SMON when event 10906 is set. Database with segments is such a transient state cannot be downgraded. The procedure can be used to fix the state of such segments.

Syntax

TABLESPACE_FIX_SEGMENT_STATES(Tablespace_Name);

Parameters

Table 61-13 Parameter for TABLESPACE_FIX_SEGMENT_STATES

Parameter Name	Purpose	Datatype	Parameter Type
Tablespace_Name	Name of the tablespace whose segments needs to be fixed.	VARCHAR	IN

Usage Notes

The tablespace must be kept online and read write when this procedure is called.

Example

execute dbms_space_admin.tablespace_fix_segment_states('TS1');