Skip to Content
avatar image
Former Member

Advanced DSO Partitioning on Year/period

Hello All,

Im working on a scenario where the we need to partition Advanced DSO as it is likely that we get close to 2 Billion records for a Year.

We are trying to do a partition for the first time. Would appreciate if you could share your experience on the following .

1. Is Upper limit for the range partion inclusive or exclusive?

2. Where can see the table names for the partitions ? ( to cross check if the selected partitions are updated as intended).

3. Can we go on adding partitions later every year?

4. any any point of time our plan is to hold only last 10 Years data, if we archive or delete data from ADSO, can we also delete the patition and reuse that table space?

Thankyou.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers