cancel
Showing results for 
Search instead for 
Did you mean: 

Error while instaling support pack SAPKITLQD8

Former Member
0 Kudos
57

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

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

Anil

Former Member
0 Kudos

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
0 Kudos

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