here you have examples.
* do not use global indexes over partitioned table - exchange partition fails, worse maintenance
* bitmap indexes are sensitive for update of indexed columns. causes deadlocks in concurrent environment
Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.