on 03-26-2007 7:22 PM
IN DB13 - Database Check, I am getting this error:
BR0969I Checking database administration...
BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPU3P.BCACT, value: PSAPU3P620
BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPU3P.BCACT~0, value: PSAPU3P620
BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPU3P.BCCOM, value: PSAPU3P620
BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPU3P.BCCOM~0, value: PSAPU3P620
I can not find the value of PSAPU3P620 in any of these notes mentioned in SAP Note PSAPU3P620:
desc "SAPU3P"."TSORA"
desc "SAPU3P"."IAORA"
desc "SAPU3P"."TAORA"
desc "SAPU3P"."DD09L";
How can I fix this problem?
Hi William,
I think you'll find the solution at note 655162.
Best Regards,
JC Llanes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SELECT DISTINCT TABSPACE, INDSPACE FROM "SAPU3P"."TSORA";
TABSPACE INDSPACE
PSAPU3PUSR PSAPU3PUSR
PSAPU3P620 PSAPU3P620
PSAPU3P PSAPU3P
PSAPU3P700 PSAPU3P700
SELECT TABNAME, TABART FROM "SAPU3P"."DD09L" WHERE TABNAME = 'BCACT';
TABNAME TABART
BCACT APPL0
SELECT TABART, TABSPACE FROM "SAPU3P"."TAORA" WHERE TABART = 'APPL0';
TABART TABSPACE
APPL0 PSAPU3P
SELECT TABART, TABSPACE FROM "SAPU3P"."IAORA" WHERE TABART = 'APPL0';
TABART TABSPACE
APPL0 PSAPU3P
So where is this warning coming from:
BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPU3P.BCACT, value: PSAPU3P620
SELECT DISTINCT TABSPACE, TABART FROM "SAPU3P"."TAORA";
TABSPACE TABART
PSAPU3P DFACT
PSAPU3P DODS
PSAPU3P TEMP
PSAPU3P APPL0
PSAPU3P APPL1
PSAPU3P700 SLDEF
PSAPU3P SDIC
PSAPU3P APPL2
PSAPU3P DDIM
PSAPU3P SPROT
PSAPU3P700 SSDEF
PSAPU3P SDOCU
PSAPU3P SSRC
PSAPU3P POOL
PSAPU3P SLOAD
PSAPU3PUSR USER
PSAPU3P CLUST
PSAPU3P700 SLEXC
PSAPU3P700 SSEXC
PSAPU3PUSR USER1
20 rows selected
Let's make another approach:
1. Transaction SE11: BCACT as database table -> display, then go to Technical settings and note the data class associated with BCACT (APPL0 ?)
2. Transaction SE16: TAORA as table name, then F7, then F8 to note the association between the data class and the tablespace.
If BCACT is not in the correct tablespace, you'll have to relocate this table in the correct tablespace with brspace.
3. Perform the same with the other objects.
Hope this helps.
Christophe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.