part_oltp
materialized views
clustered tables
clustered index

local for datawarehouse and global for oltp
http://docs.oracle.com/cd/B10501_01/server.920/a96524/c12parti.htm#429785 9i
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_7002.htm#SQLRF01402 11g

http://docs.oracle.com/cd/B28359_01/index.htm
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_1009.htm#SQLRF00805
http://docs.oracle.com/cd/E48246_01/doc.1111/e36891/partition.htm

partition