Error while instaling support pack SAPKITLQD8

[Former Member]

hi All,

I am getting error when when i am applying support pack SAPKITLQD8

as per the log it is showing as...

-

---

13:25:00: Retcode 1: error in DDL statement for /SDF/CMO_SMDDVC - repeat

Error 1031-ORA-01031: insufficient privileges when executing ADD-FIELD of

Error in DDL statement for when executing ADD-FIELD of

(dummy, do not translate)

No DDL commands found for activation of /SDF/CMO_SMDDVC

-

---

we have all the sufficient previlages for 'SAPR3'

-

---

SQL> select grantee, granted_role, default_role from dba_role_privs where grantee = 'SAPR3';

GRANTEE GRANTED_ROLE DEF

-

---

-

---

---

SAPR3 CONNECT YES

SAPR3 RESOURCE YES

SAPR3 SELECT_CATALOG_ROLE YES

SAPR3 EXECUTE_CATALOG_ROLE YES

-

---

Thanks,

srikanth.

[Former Member]

Hi,

Pls give the permission. This is related to your permission.

Anil

[Former Member]

HI

please check this out hope this will solve ur problem

Note 985607 - ORA-01031 Creating views after upgrade to Oracle 10g

Note 834917 - Oracle Database 10g: New database role SAPCONN

Regards

dEE

[Former Member]

Hi Srikanth,

If you receiving this error(Error 1031-ORA-01031) In most cases, lacks a privilege to create an object, so provide neccessary privileges.

Regards

Chandra