convert week_data to partitioned table
We are on RMS 10 and database version is 9208. The week_data table is heap table & We need to get clarification whether or not such an old release of RMS supports Partitioning.
From the Oracle DBMS side 9i supports partitioning, but some older app’s there may have some dependencies via a key, where a composite and/or a new partition key may create and
access and performance problems. And that is a more complex issue as we may need to modify the app.
Also week_data in newer releases of RMS is part on EOW_DATE and Sub HASH partition on location (column). Whereas location is not a column on the older version that we are running which is RMS10.