BR0886E and error -2515

[former_member182034]

Dear all,

I just applied Oracle Patch 10205 and when i am trying to run brtools or system export then i m getting below errors.

BR0886E Checking/collecting statistics failed for table SAPSR3./1CN/CTXSAPD0004
BR0280I BRCONNECT thread 2: time stamp: 2012-01-31 10.39.34
BR0301E SQL error -25153 in thread 2 at location stats_tab_collect-20, SQL statement:
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME
 => '"/1CN/CTXSAPR0140"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE
 => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'
ORA-25153: Temporary Tablespace is Empty

how can i rectify this error.

Regards,

[Former Member · Accepted solution]

Hi,

>> ORA-25153: Temporary Tablespace is Empty

Did you created a temporary tablespace? You can check it on DB02

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

DB02 -> Space -> Tablespaces -> Overview

Check the sizeof (PSAPTEMP). It shouldn't be "0" length

Best regards,

Orkun Gedik

[former_member182034 · Accepted solution]

hi Orkun,

the status of PSAPTEMP is:

PSAPTEMP 	0.00 	0.00 	0 	NO 	0.00 	0.00 	0 	0 	0 	0 	ONLINE 	TEMPORARY 	DISABLED

now i have to extend this PSAPTEMP but tell me value?

Regards,

[Former Member · Accepted solution]

Hi Jamil,

Modify the statements below regarding your needs and apply;

CREATE TEMPORARY TABLESPACE "PSAPTEMP1" TEMPFILE '/oracle/<SID>/sapdata<x>/temp_2/TEMP.DATA2' SIZE <Size of temporary tablespace> reuse autoextend off;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP1;

DROP TABLESPACE PSAPTEMP INCLUDING CONTENTS;

CREATE TEMPORARY TABLESPACE "PSAPTEMP" TEMPFILE '/oracle/<SID>/sapdata<x>/temp_1/TEMP.DATA1' SIZE <Size of temporary tablespace> reuse autoextend off;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP;

DROP TABLESPACE PSAPTEMP1 INCLUDING CONTENTS;

Best regards,

Orkun Gedik

[former_member182034 · Accepted solution]

hi Orkun,

thx respected Orkun for your reply.

dear. that error resolved but now getting following error.

3 + Delete harmful statistics

BR0292I Execution of BRCONNECT finished with return code 1
BR0668I Warnings or errors occurred - you can continue to ignore them or go back
 to repeat the last action
BR0280I BRTOOLS time stamp: 2012-01-31 16.29.32
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

please explain why Return Code 1 is occurring.

and

there are 4 temp files (TEMP.DATA1,TEMP.DATA2,TEMP.DATA3.TEMP.DATA4) in sapdata1/. may i delete these file or not.

please send me delete/drop commands for TEMP.DATA2,3,4 files and how can i check the active TEMP file?

Regards,

[Former Member · Accepted solution]

Hi my friend,

"Return Code 1" means that the execution with warning(s). You can check the error details on "c<encoded timestamp>.dst" and "conn<SID>.log", under "/oracle/<SID>/sapcheck"

Best regards,

Orkun Gedik