dbcheck warnings

[mohsin_m3]

Hello All,

Dbcheck finished with below warnings

DB14 latest file .... .chk file

BR0989W Unknown tablespace PSAPES30BD defined in table SAPSR3.TAORA for table data class 'USER2'

BR0989W Unknown tablespace PSAPEL30BD defined in table SAPSR3.TAORA for table data class 'USER3'

BR0989W Unknown tablespace PSAPES30CD defined in table SAPSR3.TAORA for table data class 'USER4'

BR0989W Unknown tablespace PSAPEL30CD defined in table SAPSR3.TAORA for table data class 'USER5'

Pls help me to resolve the issue.

Regards

Mohsin

[mohsin_m3]

ok

[Former Member]

Hi,

You need to update the dataclasses for the mentioned Tabelspaces in table TAORA & also check in table IAORA

Thanks

Sushil

[Former Member]

Hi,

If it is not Production update TAORA table by update statement

Whichversion your using ???

SQl> connect / as sysdba

SQL> update sapsr3.taora set tablespace ='PSAPSR3'

where tablespace_name='PSAPES30BD';

(depends on R/3 version)

[mohsin_m3]

Ya its IDES not production system.

[anindya_bose]

Hi Mohsin

Technically you can update any table from database level. But that is not something RECOMMENDED by SAP.

You can change those entries from SE16 only if you have authorization to do that.

Select one tablespace entry (which is invalid one) and then click on change.

Please check tables TSORA,IAORA and TAORA in all your system and look for any inconsistencies there.

Please also check Note 655162 - BRCONNECT messages in relation to technical settings

Thanks and Regards

Anindya

[former_member204746]

try this:

sqlplus "/ as sysdba"

delete from sapr3.taora where tabspace is like 'PSAPE%30%'

[anindya_bose]

Hi Mohsin

Check table TAORA from se16. Probably it contains some tablespace name which is obsolete for your system

Thanks and Regards

Anindya

[mohsin_m3]

Hi Anindya,

Yes it is showing in se16 same....

can u pls tell me steps what action i should be taken ?

Regards

Mohsin