Moving data around between tablespaces may sometimes be required.
First, create your tablespaces. Once the old and new tablespaces exist, we can issue the commands to move them.
Tablespaces can contain both permanent and temporary objects.
Permanent data objects are tables, indexes, and toast objects. We don't need to worry too much about toast objects, because they are created and always live in the same tablespace as their main table. So if you alter the tablespace of a table, it's toast objects will move also.
ALTER TABLE mytable SET TABLESPACE new_tablespace;
Indexes can exist in separate tablespaces, and moving a table leaves the indexes where they are. Don't forget to run