DDL STATEMENT FAILED

251 Views

hi ,

At the end of database instance in kernel installation after completing r3 load job-- sap view finished. but one error was thrown in log.

before seeing error i gave retry and installation closed. Then went to set up and logged in sap 4.7 but coulnd not get connected. what should be done now.PLS HELP.

(db) error: ddl statement failed

(create view "appl_mods" ( "name" , "typ" , "member" , "devclass" ) as select t0001."name", t0001."typ", t0001."member", t0002."devclass" from "modsap" t0001, "modsapa" t0002 where t0001."name" = t0002."name" and t0002."migrated" <> 'x')

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=0027d470,usrhp=00291bec)

dbsl trace: detaching from db server (con_hdl=0,svchp=0027d470,srvhp=0027d27c)

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: 20070828232723