Hi,
I am trying to copy a partition form one table to another.
I have TableA that is subpartitioned into approx 200 subpartitions. It holds approx 20mill rows of data in the whole table. At any one time I only want to work with data from one subpartition which will contain on avergae 1.5 million rows (not all subpartitions are filled or equal size).
Can I move this data to another table without actually removing the data from Table A?
I use EXCHANGE PARTITION elsewhere but this removes the data from TableA and puts it in TableB.
So every time I want to work with new data I will truncate Table B and then COPY SUBPARTITION from TableA to Table B.
Any help is greatly appreciated.