Oracle Database Discussions

We would really like to be able to use the same partition across multiple tables. From reading the docs, it doesn't seem that partitioned tables allows you to do this. However, partitioned views, which is unfortunately now deprecated, does (did?). Is there a new way to accomplish what we need in the world sans partitioned views?

For those who are curious, here's the business problem:

We have a set of related tables that build off one another and a process that updates them every night. This process must run while the application that uses them is still up and running. However, the entire set of tables must be made live at one time or strange things will happen in the application.

Right now, we build a new copy of each table. When one table depends on another we build them in order, using the new-but-not-yet-live copy of each table. Only when all tables are done rebuilding do we flip a bit in the application to make it use the new copies.

We would like to refine this process by dividing all the tables down by time and only updating the most recent one or two partitions of each table. However, a lot of the benefit of doing this would be lost if we had to first make copies of each unchanging partition. It would be nice if our "live" copy of each table could share partitions with the "new" copy.