Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ORA-00942: table or view does not exist

Hi

I am trying to install sap with oracle 10g on windows 2003 it throws up the error at a particular stage:

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) ERROR: DDL statement failed

(DROP VIEW "/1SAP1/CNV_A0017")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE VIEW "/1SAP1/CNV_A0017" ( "MANDANT" , "KEYGUID" , "OBJECTCLAS" , "OBJECTID" , "TABNAME" , "TABKEY" ) AS SELECT T0001."MANDANT", T0001."KEYGUID", T0001."OBJECTCLAS", T0001."OBJECTID", T0001."TABNAME", T0001."TABKEY" FROM "CDPOS_UID" T0001)

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(DB) INFO: disconnected from DB

D:\usr\sap\ECC\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

D:\usr\sap\ECC\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20150606151913

D:\usr\sap\ECC\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20150606152200

D:\usr\sap\ECC\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

D:\usr\sap\ECC\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Apr 2 2006 23:26:45

D:\usr\sap\ECC\SYS\exe\uc\NTI386\R3load.exe -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -stop_on_error

Please could you let me know what it relates to and how to rectify this.

Former Member
Not what you were looking for? View more on this topic or Ask a question