Database Administration (MOSC)

MOSC Banner

convert week_data to partitioned table

edited Mar 14, 2018 5:24AM in Database Administration (MOSC) 6 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center