on 08-29-2007 6:29 AM
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>
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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');
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.