Move segments in the SYSAUX datafile
How to move segments from sysaux datafile to another datafile, so that the datafile can be dropped?
For example :
For example :
WRH$_EVENT_HISTOGRAM_PK INDEX PARTITION 21 2557088 65,536 WRH$_EVENT__2976474580_0
WRH$_SQLSTAT TABLE PARTITION 21 2557096 65,536 WRH$_SQLSTA_2976474580_0
free 21 2557104 65,536
WRH$_SYSSTAT TABLE PARTITION 21 2557112 65,536 WRH$_SYSSTA_2976474580_0
WRH$_PARAMETER_PK INDEX PARTITION 21 2557120 65,536 WRH$_PARAME_2976474580_0
WRH$_EVENT_HISTOGRAM TABLE PARTITION 21 2557128 65,536 WRH$_EVENT__2976474580_0
free 21 2557136 393,216
WRI$_OPTSTAT_IND_HISTORY TABLE 21 2557184 1,048,576
free 21 2557312 3,824,156,672
Here FIle ID is 21. I would like to move the segments to another datafile so that the datafile 21 can be dropped. Is there any such option?
Here FIle ID is 21. I would like to move the segments to another datafile so that the datafile 21 can be dropped. Is there any such option?
0