Solution : https://service.sap.com/sap/support/notes/682926 (SAP Service marketplace login required)
Summary :
SAP users report various issues with online index creation and rebuild operations, including ORA-08104 and ORA-08106 errors, suggesting problems with object creation or journal table conflicts. Locks on entire tables during operation and CPU resource non-utilization concerns are noted, potentially leading to failure signs as operations appear to hang. Additional problems include Oracle dictionary damage by index rebuilds, corruption post-tablespace recovery, and transaction failures due to maximum extent limits. Operational conflicts might also arise from parallel index operations leading to various Oracle wait issues, affecting system performance and data integrity.
Key words :
analyze table <table> validate structure cascade online, select st04->detailed analysis->oracle sessions, subsequently explicit statistics calculation transfers, terms alter index rebuild online problems, alter tablespace <tablespace> default storage, index online rebuild/create proceed, attempt usingset serveroutput onbegin, journal table called sys_journal_<, index corruption/wrong results, alter index rebuild online
Related Notes :
| 915242 | FAQ: Reverse key indexes |
| 869521 | Oracle <= 10g: TM locks with REBUILD ONLINE / CREATE ONLINE |
| 825653 | Oracle: Common misconceptions |
| 806554 | FAQ: I/O-intensive database operations |
| 745639 | FAQ: Oracle enqueues |
| 691764 | RSANAORA enhancement: online option for index rebuild |
| 539921 | Current patch set for Oracle 9.2.0 |
| 332677 | Rebuilding fragmented indexes |
| 214995 | Oracle locally managed tablespaces in the SAP environment |