Solution : https://service.sap.com/sap/support/notes/741478 (SAP Service marketplace login required)
Key words :
architectureoracle9i sql reference-> create materialized view refer, oracle9i advanced replication-> 3 materialized view concepts, alter table <table> add primary_key, create large i_snap$ indexes implicitly, create materialized view my_mat_view<refresh_mode>, increased redo log count, significant redo log count, avoid reorganizing large tables, 30 minutes equals 1 day multiplied, create materialized view authorization
Related Notes :
646681 | Reorganization of tables with BRSPACE |
584548 | Unusually high number of redo logs |
541538 | FAQ: Reorganization |
105047 | Support for Oracle functions in the SAP environment |