archiving vs partioning
What are your thoughts on archiving vs partitioning. The archived data will be in the same database under a different schema instead of in a different database.
The pros and cons on when should we go for archiving vs partitioning will be helpful. Database version is 9208