I'd be really careful when considering partitioning (either partitioned tables or views) just for purposes of archiving. There are a whole lot of caveats (for example, partitioned column is added to all unique indexes in partitioned tables making them non-unique unless it's the only column in the index) to partitioning to the point that I tell people "if you partitioned a table and thought it was easy, you probably did something wrong". 😉 Yeah... it's real nice to do nearly instant SPLITs and the like but there can be a lot of other baggage that goes along with it.