on 03-17-2016 9:29 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.