IN_WRONG_TABLESPACE in DB check via Brtools

[Former Member]

Dear Experts,

We have run DB check via BRtools, got below errors:

BR0280I BRCONNECT time stamp: 2012-08-20 08.22.46

BR0969I Checking database administration...

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPINTF.HR_ALL_ORGANIZATION_UNITS, value: PSAPPRDUSR

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPINTF.PO_HEADERS_ALL_OLD, value: PSAPPRDUSR

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPINTF.PO_HEADERS_U1, value: PSAPPRD

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPINTF.PO_LINES_ALL_OLD, value: PSAPPRDUSR

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPINTF.PO_LINES_N5, value: PSAPPRD

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (index) SAPINTF.PO_LINES_U2, value: PSAPPRD

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPINTF.XXXPO_HEADERS_ALL_OLD, value: PSAPPRDUSR

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPINTF.XXXPO_LINES_ALL_OLD, value: PSAPPRDUSR

Some Analysis from end:

Output from TSORA:

TablespaceName    Tablespace name of index

PSAPPRD PSAPPRD

PSAPPRD701    PSAPPRD701

PSAPPRDUSR    PSAPPRDUSR

Output from TAORA:

APPL0 PSAPPRD        1 1    10    40

APPL1    PSAPPRD 1    1    10    40

APPL2    PSAPPRD 1    1    10    40

CLUST    PSAPPRD 1    1    10    40

DDIM    PSAPPRD 1    1        60

DFACT    PSAPPRD 4    1    10    60

DODS    PSAPPRD 4    1        60

POOL    PSAPPRD 1    1    10    40

SDIC    PSAPPRD 1    1    10    40

SDOCU    PSAPPRD 1    1    10    40

SLDEF    PSAPPRD701 1    1    10    40

SLEXC    PSAPPRD701 1    1    10    40

SLOAD    PSAPPRD 1    1    10    40

SPROT    PSAPPRD 1    1    10    40

SSDEF    PSAPPRD701 1    1    10    40

SSEXC    PSAPPRD701 1    1    10    40

SSRC    PSAPPRD 1    1    10    40

TEMP    PSAPPRD 1    1    10    40

USER    PSAPPRDUSR 1    1    10    40

USER1    PSAPPRDUSR 1    1    10    40

Output from IAORA:

APPL0 PSAPPRD        1    10

APPL1    PSAPPRD 1    10

APPL2    PSAPPRD 1    10

CLUST    PSAPPRD 1    10

DDIM    PSAPPRD 1    10

DFACT    PSAPPRD 4    10

DODS    PSAPPRD 4    10

POOL    PSAPPRD 1    10

SDIC    PSAPPRD 1    10

SDOCU    PSAPPRD 1    10

SLDEF    PSAPPRD701 1    10

SLEXC    PSAPPRD701 1    10

SLOAD    PSAPPRD 1    10

SPROT    PSAPPRD 1    10

SSDEF    PSAPPRD701 1    10

SSEXC    PSAPPRD701 1    10

SSRC    PSAPPRD 1    10

TEMP    PSAPPRD 1    10

USER    PSAPPRDUSR 1    10

USER1    PSAPPRDUSR 1    10

SQL> select tablespace_name from dba_indexes where index_name like 'PO_HEADERS_U1';

TABLESPACE_NAME

------------------------------

PSAPPRDUSR

PSAPPRD

SQL> select tablespace_name from dba_indexes where index_name like 'PO_LINES_N5';

TABLESPACE_NAME

------------------------------

PSAPPRDUSR

PSAPPRD

SQL> select table_name,tablespace_name from dba_tables where table_name like 'XXXPO_HEADERS_ALL_OLD';

TABLE_NAME TABLESPACE_NAME

------------------------------ ------------------------------

XXXPO_HEADERS_ALL_OLD PSAPPRDUSR

SQL> select table_name,tablespace_name from dba_tables where table_name like 'HR_ALL_ORGANIZATION_UNITS';

TABLE_NAME TABLESPACE_NAME

------------------------------ ------------------------------

HR_ALL_ORGANIZATION_UNITS      PSAPPRDUSR

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME

------------------------------

SYSTEM

PSAPUNDO

SYSAUX

PSAPTEMP

PSAPPRD

PSAPPRD701

PSAPPRDUSR

7 rows selected.

Even I checked se16, it's showing table <table_name> is not active in dictionary.

BrTools version: 7.20(23); Oracle 10.0.2.0; SAPBASIS 701(0007)

Please suggest!!!!!!!!!!!

[Former Member]

Going further:

1. above objects (output from DB check) exist at database level, but not in se11,se16. so data class couldn't found.

2. all tablespaces exist at database level as well as in IAORA,TSORA,TAORA

[JPReyes]

This must be due to an inconsistency in between the dictionary and the database.

Check DB02 -> Diagnostics -> Missing tables and indexes.

Regards, Juan

[Former Member]

  Yes, we have found missing objects in DB02 & DB check log file.

  Please suggest further action....

[JPReyes]

Well you need to make the consistent. right?...

Check with your abaper if those tables/indexes are safe to be re-created...

Regards, Juan

[Former Member]

Hi,

  BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPINTF.HR_ALL_ORGANIZATION_UNITS, value: PSAPPRDUSR

Problem resolved, actually, in above errors, there should be correct schema owner name instead of SAPINTF.