Posted: 24 Oct 2017 11:35 EDT Last activity: 25 Oct 2017 17:54 EDT
migrating to AWS, question about some large tables
our installation is migrating from home-hosted to AWS. looking to move the Oracle DB, our DBA has raised a question about some large tables, whether they need to be migrated.
Looks to me like there is a Pega installation with RULE & DATA in separate schemas, and another instance for AES.
These files are collectively about 60GB. They have not been accessed since about 12 months back. That feels like around the time we migrated PRPC versions. Are they perhaps leftover temporary files from the migration?
***Edited by Moderator Marissa to update categories/SR Details***
I haven't received the table structure yet but I did a little googling and these tables were created by Oracle. They are related to compression advisory. From what I see it looks like these are temporary tables that will be deleted at some point but from some posts it does not look like they are deleted in a timely manner. I would ask Oracle about them but I would not expect that they need to be migrated.