Skip to Content
0
Former Member
Jun 08, 2010 at 02:09 PM

Running Update Statistic--getting below error message

58 Views

Hi All,

I am getting below error message when i run the update statistic in QAS system...DEV and PRD system no issues.We are having ECC 6.0 using oracle ( Linux).

BR0881I Collecting statistics for table SAPSR3.TBTCS with method/sample C ...

BR0280I BRCONNECT time stamp: 2010-06-08 13.25.50

BR0301E SQL error -1114 at location stats_tab_collect-20, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"TBTCS"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'

ORA-01114: IO error writing block to file 255 (block # 72202)

ORA-27041: unable to open file

Linux-x86_64 Error: 13: Permission denied

Additional information: 3

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 SAPSR3.TBTCS

Can some one help me out for the solution.

Thanks.

Vel.