title: Oracle SQL: Selecting data and partition name from table and truncating partitions
body: <p>This is a two part question:</p>
  
  <p>1) Is it possible to retrieve the name of the partition that data lives in using a select statement, based on its <code>ROWID</code> or some other identifier?</p>
  
  <p>eg.</p>
  
  <pre><code>SELECT DATA_ID, CATEGORY, VALUE, **PARTITION_NAME**
  FROM MYTABLE
  WHERE CATEGORY = 'ABC'
  </code></pre>
  
  <p>2) Is it possible to truncate a single partition of a table, without deleting the data stored in the other partitions?</p>
  
  <p>I have a table with over a billion rows, hash partitioned by category.  Only a handful of the categories have problems with their data, so it does not make sense to recreate the entire table, but deleting data from the table, even with all constraints inactive, is taking far too long.</p>