In order to move a partitioned table to a different tablespace, each partitioned has to be moved. This can be accomplished two ways: manually moving each partitioned or writing a procedure that will loop through each partition and move it. I will discuss how to write a procedure to take care of this task. First, a partitioned table needs to be created and have some values inserted into it. This table is created in the HR schema and partitioned by range:
Viewing entries tagged
moving partitioned tables