question

BI DWH BALA avatar image
BI DWH BALA asked

List-Range partition in Oracle 10G?

Hi,

Is it possible to create a partition by list and by range?

I am using Oracle 10G.

Thank you, Regards

BI DWH BALA

oracle
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Andrew Mobbs avatar image
Andrew Mobbs answered

In 10g the only composite partitions available are range-list and range-hash (i.e. with range leading).

In 11g you can have range-list, range-hash, range-range, list-range, list-list, and list-hash.

You may be able to fake a list-range scheme in 10g by using a view on a set of tables UNION'd together and INSTEAD OF triggers to direct the DML to the right underlying table. However, that may be a bad idea for a number of reasons around maintainability.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

BI DWH BALA avatar image BI DWH BALA commented ·
Thank you Andrew. As you said, it would be maintainability problem. I won't go for this option. I will check with my team and will change my design. Thanks once again!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.