SAP Knowledge Base Article - Preview

2899006 - BR*Tools fails with ORA-00942 on table SYS.SEG$

Symptom

  • BR*Tools fails with ORA-00942 on table SYS.SEG$, although the table exists in the database.


Following is an example for BRCONNECT:
BR0280I BRCONNECT time stamp: ***
BR0301E SQL error -942 at location BrLicCheck-177, SQL statement:
'SELECT COUNT(*), NVL(SUM(BLOCKS), 0) FROM SYS.SEG$ WHERE USER# = <n>'
ORA-00942: table or view does not exist

  • Or 

BR0301E SQL error -942 at location BrDbConnect-10, SQL statement:
'SELECT INSTANCE_NAME, INSTANCE_NUMBER, NVL(HOST_NAME, ' '), NVL(VERSION, ' '), NVL(STATUS, ' '), NVL(LOGINS, ' '), NVL(ARCHIVER, ' '), NVL(PARALLEL, ' '), NVL(TO_NUMBER(TO_CHAR(STARTUP_TIME, 'YYYYMMDDHH24MISS')), 0), TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') FROM V$INSTANCE'
ORA-00942: table or view does not exist


Read more...

Environment

ORACLE

Keywords

ORA-00942, SYS.SEG$, SAPDBA role, BR0301E, BR*Tools
, KBA , BC-DB-ORA-DBA , Database Administration , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.