title: Using views on tables with same schema
body: <p>We are using multiple tables to persist data of an entity month-wise. Meaning, we have table names as xx01, xx02...xx12. The table definition for all these table is same except the name. We are doing like this so that we can drop a table when we think it is old. Ex: drop Feb table in Dec. The table drop will be essentially free. 
  My question is, can I create a view which can read from any of these tables? 
  The view should be able to fetch data from any of these tables, potentially from more than one table for range queries. 
  DB: Oracle 12c.
  PS: We can't have a column for month and partition on it because we have to partition and subpartition basing on other columns for read performance.</p>