We are about to start a project to reorganize our BW instance which runs on Oracle 10.2.0.4.
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.