cancel
Showing results for 
Search instead for 
Did you mean: 

Tables DB* in tablespace SYSTEM

willi_eimler
Contributor
0 Kudos

Hi All,

because of the error message:

BR0966I Table DBCHECKORA not found or empty - using default settings for checks

I discovered that all DB- tables:

     DBCHECKORA

     DBMSGORA

     DBSTAIHORA

     DBSTATC

     DBSTATHORA

     DBSTATIORA

     DBSTATTORA

are in SYSTEM tablespace instead of PSAPSR3DB. The system is a j2ee with own ORACLE database (11.2.0.4). It was created by a "Dual Stack Split". After that it was migrated from HPUX to LINUX.

My Questions:

     1. Is it correct for a j2ee that the DB tables exists in SYSTEM tablespace?

     2. If they are in wrong tablespace, why are they in tablespace SYSTEM now?

     3. If they are in wrong tablespace, is it possible to move them in tablespace SYSTEM with table move?

Best regards

Willi Eimler

Accepted Solutions (1)

Accepted Solutions (1)

willi_eimler
Contributor
0 Kudos

Hi All,

problem found. OSS 1139623 was implemented with "sqlplus / as sysdba". instead of "sqlplus sap<schema_id>/<pwd>".



Now I have to implement OSS 1139623 again.



Best Regards

Willi Eimler

Answers (0)