title: How to move schema objects to a different tablespace
body: <p>I am using Oracle database 12c. 
  I understand that a tablespace is a logical storage unit made up of one or more datafiles in which data about schema objects is stored. I also understand how to create tablespaces.</p>
  
  <p>My question is: Which schema objects can be assigned to different tablespaces? How can we assign these objects to a tablespace using SQL? </p>
  
  <p>EDIT:</p>
  
  <p>I have found that to move a table to a different tablespace, we use the following syntax:</p>
  
  <pre><code>ALTER TABLE &lt;TABLE NAME to be moved&gt; MOVE TABLESPACE &lt;destination TABLESPACE NAME&gt;
  </code></pre>
  
  <p>Additionally, to move a corresponding index to a tablespace, we use the following syntax after executing the above query:</p>
  
  <pre><code>alter index &lt;owner&gt;."&lt;index_name&gt;" rebuild;
  </code></pre>
  
  <p>However, are there any more schema objects that can be moved to a tablespace like the above?</p>