Database DataWarehousing (MOSC)

MOSC Banner

Partitioning question

edited Oct 20, 2016 12:30PM in Database DataWarehousing (MOSC) 4 commentsAnswered ✓

Hi,

I have a question regarding partitioning the table. We have a table with 200M+ records and it's growing on daily basis. We have to apply lots of updates everyday and and it takes quite a bit to update this table. i was reading oracle documentation on partitioning and I kind a have some knowledge on this subject. But I was wondering if there is any possibility to create partition on customer_id which is very common field in many of our tables. We have many DMLs surround customer_id column. For example, customer_id like P123, H234, D888 etc. we can create list

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