Database Tuning (MOSC)

MOSC Banner

Large Table Partition

edited Apr 23, 2018 5:05AM in Database Tuning (MOSC) 3 commentsAnswered

Hi,

While doing partition for large table(more then 1 TB) what kind of precaution need to take?

And we are containing two year data in table and trying do RANG partition based on date column. However i have one doubt, from table each month we will delete one month data e.g. let assume we have data since 1-Jan-2015 to 31-Dec-2016. Now if we insert data for Jan 2017 month then Jan 2015 data will be archived. For this how we can approach for partition.

Thanks,

Br

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