We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] Update Stats Failed after DB Refresh in SAP

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by Reev (SAP Basis & NetWeaver)
on Jul 20 at 1:31 AM 		Mark this reply as helpfulMark as helpful
Thanks Chen,
I know how to recover from backup,
I also want to know how to rebuild a corrupt data block, can help me.

regards,
Reev.


---------------Original Message---------------
From: Reev
Sent: Monday, July 19, 2010 10:45 PM
Subject: Update Stats Failed after DB Refresh in SAP

> BR0301E SQL error -1578 at location stats_tab_collect-16, SQL statement:
> ORA-01578: ORACLE data block corrupted (file # 31, block # 236798)
> ORA-01110: data file 31: '/oracle/BWI/sapdata3/bip_19/bip.data19'
> ORA-26040: Data block was loaded using the NOLOGGING option
> ORA-06512: at "SYS.DBMS_STATS", line 13437
> ORA-06512: at "SYS.DBMS_STATS", line 13457
> ORA-06512: at line 1
> BR0886E Checking/collecting statistics failed for table SAPBIP./BIC/FHFBCS_C10

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language