Hi,
Oracle version details:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
"CORE 10.2.0.5.0 Production"
TNS for Solaris: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
we have a partitioned table T_WI_ALERTS_STATUS, the partitions are created on date range for each month.
The partitions are in below format
STATUS_WI_DAT_201808
STATUS_WI_DAT_201809
STATUS_WI_DAT_201810
STATUS_WI_DAT_201811
STATUS_WI_DAT_201812
For month 201810 the partition was not created due to some issue that is different.
So the data for month 201810 was inserted in 201811 partition.
Now we have created 201810 partition and wanted to move October month data from 201811 to 201810
So here my question is how to move data from one partition to another.
Thanks.
Message was edited by: 913578