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.

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