Hi all,
From production to development instances of BW, I remark that all procedures are in invalid status. Those procedures are started as "/BI0/<number> and the owner is sapr3.
When recompiled those invalid objects, I got only this kind of error : PL/SQL: ORA-00942: table or view does not exist
I did verify 1 procedure, and effectively the table used in the procedure does not exist.
My questions are :
1) Is it normal that those procedures exist but the objects used donot exist ?
2) Can I drop those invalid procedures ? Do I need a consent of SAP support ?
3) In case I cannot drop them, how can I put them in valid status ?
Thanks for your input.
Hai-Thuy.