Invalid views

[Former Member]

I have been an Oracle DBA for some years now but I am completely new to SAP. I have just added our SAP installations to our Oracle 10g grid control and am being warned about invalid objects on the database.

It looks like there are 9 views that can not be compiled because they are referring to non existing tables. Is it safe to remove these views (or does SAP create tables itself and can the views be compiled later on) ?

Names of the views:

/BI0/0300028350

/BI0/0300023408

/BI0/0300024863

/BI0/0300022129

/BI0/0300002129

/BI0/0300024455

/BI0/0300023643

/BI0/0300032942

/BI0/0300032943

[Former Member · Accepted solution]

SAP does have it's own metadata store, so it know how to create tables, indexes and views. These BW/BI views are probably of an InfoObject which has been removed or deactivated.

[Former Member · Accepted solution]

Is it save then to remove these views ? Can I do further investigation on an InfoObject which has been removed or deactivated ?

Message was edited by:

A. Langers

[former_member204746 · Accepted solution]

I would use a BW forum for these questions.

[Former Member · Accepted solution]

I will move my question to the forum you mentioned