title: Oracle Database: How can I alter a partitioned table to a new table space for not only the partitions but also the table itself?
body: <p>How can I alter a partitioned table (in Oracle 10g Database) to a new table space for not only the partitions but also the table itself? Which I mean is, I can do following without issues,
  --sql
  alter table abc move partition abc01 tablespace new_tablespace;
  alter table abc move partition abc02 tablespace new_tablespace;
  alter table abc move partition abc03 tablespace new_tablespace;</p>
  
  <p>but somehow the table's definition is still associating with the old table space, and and I have moved all tables data off the old table space. If I query the dba_segment for the old table space, there is nothing there. My question is, may I drop the old table space, even no data in the data files in the old table space, but somehow those partitioned tables definitions still associating with the old table space?</p>