Skip to Content
Former Member
Jun 17, 2009 at 09:21 AM

Reorg Oracle Database for BW



We are about to start a project to reorganize our BW instance which runs on Oracle

This operation is well know by our company.

Yet, we are not really expert on dedicted points regarding BW and reorganizing.

Does anyone has guidelines or best practices to reorganize huge BW tables ?

Is it a good idea to put huge BW tables in a dedicated tablespace (as we did on R3) or not ?

Is it a good idea to put PSA tables in a dedicated tablesspace ?

Thanks for your answer.