Error occured during creation of oracle snapshot

今天登录BW生产服务器，发现收到大量SAP邮件，内容如下：

 

Error occured during creation of oracle snapshot (Creation aborted)
(Log see also transaction SLG1, Object ORASNAP, Subobject ORASNAPCR)
Oracle snapshot creation program aborted
Error while copying from oracle view to SAP table
Oracle view SAP$KCBFWAIT
SAP table ORA_SAPKCBFWAIT
Return code (ORA-....) 942
You tried to work with the name of a table or view that does not exist in the database
The table does not exist on the database. A table name or view name was used that does not exist on                           the database.

到www.sdn.sap.com 论坛，找到答案：

 

It looks like there are some problems in accessing Oracle view SAP$KCBFWAIT. Apply SAP note 159510.

 

又查NOTE 159510，解决方法如下：

 

Solution

Start SQLPLUS in the database and log on as user SYS.
Afterwards execute the following commands one after another:

create or replace view sap_$ksmsp as select * from x$ksmsp;
drop public synonym sap$ksmsp;
create public synonym sap$ksmsp for sap_$ksmsp;
grant select on sap$ksmsp to public;

create or replace view sap_$kcbfwait as select * from x$kcbfwait;
drop public synonym sap$kcbfwait;
create public synonym sap$kcbfwait for sap_$kcbfwait;
grant select on sap$kcbfwait to public;

create or replace view sap_$bh as select * from x$bh;
drop public synonym sap$bh;
create public synonym sap$bh for sap_$bh;
grant select on sap$bh to public;

The missing database views (SAP$KSMSP, SAP$KCBFWAIT or SAP$BH) will then exist in the database and you can execute the transaction.