cancel
Showing results for 
Search instead for 
Did you mean: 

DDL STATEMENT FAILED

Former Member
0 Kudos

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

<b></b><b></b>

Accepted Solutions (0)

Answers (2)

Answers (2)

lbreddemann
Active Contributor
0 Kudos

Hi Vijaya,

what's irritating to me is in this statement is that the tablenames "modsap" and "modsapa" are written in lowercase and put in "-signs.

This way oracle will look the tablenames up just like this.

E.g. if there are tables named MODSAP / MODSAPA oracle won't find them, if the tables are specified in lowercase.

As the error message 942 suggests that one or both of the tables cannot be found,

please check, if the tables do exist in the db at all:

select owner, table_name from dba_tables where upper(table_name)

in ('MODSAP', 'MODSAPA');

If the tables are returned by this query, please have the tablenames either put in the create view statement in uppercase or without the "-signs.

If the tables don't exist at all, the view cannot be created and should be skipped.

KR Lars

former_member204746
Active Contributor
0 Kudos

try this:

sqlplus sap[sid]/password

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');