R/3 installation error

[Former Member]

when i m trying to install sap47EE i m getting the following error

ORA-00942: table or view does not exist

how can i solve this.

thank u

[andreas_herzog]

-> did you copy the contents of the cds/dvds to disk?

-> are you making a system copy?

GreetZ, AH

[Former Member]

i did according to installation document,

i have copied all data to HD

[markus_doehr2]

Some import did not run successfully.

Check your Oracle alert log, there may be some information about a failed statement.

--

Markus

[Former Member]

Thank u markus,

I checked the view log, but i dint understand wts the problem.

the error is

(DB) ERROR: DDL statement failed

(CREATE VIEW "/SDF/SMODICOMP" ( "OBJ_TYPE" , "SUB_TYPE" , "INT_TYPE" , "OPERATION" , "INACTIVE" , "COMPONENT" , "PS_POSID" , "SUB_NAME" , "INT_NAME" , "PGMID" , "OBJECT" , "OBJ_NAME" , "DEVCLASS" , "FCTR_ID" , "AS4LOCAL" ) AS SELECT T0001."OBJ_TYPE", T0001."SUB_TYPE", T0001."INT_TYPE", T0001."OPERATION", T0001."INACTIVE", T0003."COMPONENT", T0004."PS_POSID", T0001."SUB_NAME", T0001."INT_NAME", T0002."PGMID", T0002."OBJECT", T0002."OBJ_NAME", T0003."DEVCLASS", T0004."FCTR_ID", T0004."AS4LOCAL" FROM "SMODILOG" T0001, "TADIR" T0002, "TDEVC" T0003, "DF14L" T0004 WHERE T0001."OBJ_TYPE" = T0002."OBJECT" AND T0001."OBJ_NAME" = T0002."OBJ_NAME" AND T0002."DEVCLASS" = T0003."DEVCLASS" AND T0003."COMPONENT" = T0004."FCTR_ID" AND T0002."PGMID" = 'R3TR' AND T0004."AS4LOCAL" = 'A')

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

DbSl Trace: Disconnecting from connection 0 ...

DbSl Trace: Closing user session (con_hdl=0,svchp=0027D420,usrhp=00291B8C)

DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=0027D420,srvhp=0027D22C)

DbSl Trace: Now I'm disconnected from ORACLE

(DB) INFO: disconnected from DB

C:\usr\sap\DEV\SYS\exe\run/R3load.exe: job finished with 1 error(s)

C:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20070610114510

could u help me how to do this

vijay

[markus_doehr2]

The problem is, that the system is trying to create a view over tables, that do not exist.

This is not the Oracle alert log, check that one instead (alert<SID>.log in the saptrace folder).

--

Markus

[Former Member]

Hi

Check note 736313

Thanks

Prince Jose