Move a Table From One Tablespace to Another

Use below command to change the tablespace of a table..


ALTER TABLE tablename MOVE TABLESPACE newtablespace


You can find out details of existing tablespaces through below view..


SELECT DISTINCT * FROM DBA_TABLESPACES