on 02-05-2009 1:42 PM
Dear Gurus,
While Updating the Update stats in DB13 Calender it shows the Below mentioned error.
BR0881I Collecting statistics for table SAPPSU.EKUB with method/sample C ...
BR0280I BRCONNECT time stamp: 2009-01-18 02.23.01
BR0884I Statistics collected for table: SAPPSU.EKUB, rows old/new: 4093/6243
BR0280I BRCONNECT time stamp: 2009-01-18 02.23.14
BR0883I Table selected to collect statistics after check: SAPPSU.EQBS (4288797/6962268)
BR0280I BRCONNECT time stamp: 2009-01-18 02.23.14
BR0881I Collecting statistics for table SAPPSU.EQBS with method/sample E/P3 ...
BR0280I BRCONNECT time stamp: 2009-01-18 02.23.28
BR0301E SQL error -25153 at location stats_tab_collect-16
ORA-25153: Temporary Tablespace is Empty
BR0886E Checking/collecting statistics failed for table SAPPSU.EQBS
BR0280I BRCONNECT time stamp: 2009-01-18 02.23.30
BR0883I Table selected to collect statistics after check: SAPPSU.ESLH (278/420)
BR0280I BRCONNECT time stamp: 2009-01-18 02.23.30
BR0881I Collecting statistics for table SAPPSU.ESLH with method/sample C ...
BR0280I BRCONNECT time stamp: 2009-01-18 02.23.30
BR0884I Statistics collected for table: SAPPSU.ESLH, rows old/new: 278/420
BR0280I BRCONNECT time stamp: 2009-01-18 02.24.19
BR0883I Table selected to collect statistics after check: SAPPSU.HRS1210 (13400/25026)
BR0280I BRCONNECT time stamp: 2009-01-18 02.24.19
BR0881I Collecting statistics for table SAPPSU.HRS1210 with method/sample E/P30 ...
BR0280I BRCONNECT time stamp: 2009-01-18 02.24.19
BR0884I Statistics collected for table: SAPPSU.HRS1210, rows old/new: 13400/13400
BR0986W Index SAPPSU.HRS1210~0 is unbalanced - please rebuild the index
BR0280I BRCONNECT time stamp: 2009-01-18 02.24.38
BR0883I Table selected to collect statistics after check: SAPPSU.JGTBP00 (75747/117862)
BR0280I BRCONNECT time stamp: 2009-01-18 02.24.38
BR0881I Collecting statistics for table SAPPSU.JGTBP00 with method/sample E/P10 ...
BR0280I BRCONNECT time stamp: 2009-01-18 02.24.39
BR0884I Statistics collected for table: SAPPSU.JGTBP00, rows old/new: 75747/106197
BR0280I BRCONNECT time stamp: 2009-01-18 02.24.40
BR0883I Table selected to collect statistics after check: SAPPSU.JGTGPNR (76144/117862)
BR0280I BRCONNECT time stamp: 2009-01-18 02.24.40
Please help me to sort out this issue.
Thanks
Anbu
Hello Anbu,
the reason for this error is that you have no TEMPFILEs in your temporary tablespace (usually PSAPTEMP).
Please add one with the BR*Tools:
http://help.sap.com/saphelp_nw70/helpdata/de/1b/d20f6fe45a9e43b1856ea1b52c9612/content.htm
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My guess is that this is a refreshed system, that PSAPTEMP is temporary and that you forgot to add the TEMP datafile. you must re-add your datafile like in this comamnd:
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE 'G:\ORACLE\DEV\SAPDATA1\TEMP_1\TEMP.DATA1'
SIZE 2768M REUSE AUTOEXTEND ON NEXT 268435456 MAXSIZE 16000M;
Is my Crystal ball right?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.