I have a Oracle 12G table which is interval partitioned (monthly) and list sub-partitioned. There is no longer a requirement to sub-partition the table and hence I would like to "merge" the data in the sub-partitions into the corresponding monthly partition.
I do not want to "drop" the sub-partition and loose the data within it.
I am looking for an alternative to simply copying the data to a new partitioned table and renaming new to old
Aucun commentaire:
Enregistrer un commentaire