SAP Knowledge Base Article - Preview

3676748 - ORA-13830: SQL profile or patch with category DEFAULT already exists for this

Symptom

Creating sql patch hitting error like:

ORA-13830: SQL profile or patch with category DEFAULT already exists for this

Example:

SQL>
declare
vNameOutput varchar2(30);
begin
   vNameOutput := dbms_sqldiag.create_sql_patch(
      sql_text => 'SELECT "OBJTP","OBJYR","OBJNO","IF_DOC_BCS" FROM "SOOD" WHERE "MANDT"=:A0 AND "CRDAT" BETWEEN :A1 AND :A2',
      hint_text => 'INDEX(SOOD@SEL\$1 "newindexname")',
      description => 'SAP case',
      name => 'SAP case');
dbms_sqldiag.alter_sql_patch('SAP case','STATUS', 'ENABLED');
end;
/  2    3    4    5    6    7    8    9   10   11
declare
*
ERROR at line 1:
ORA-13830: SQL profile or patch with category DEFAULT already exists for this
SQL statement
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 18232
ORA-06512: at "SYS.DBMS_SQLDIAG_INTERNAL", line 629
ORA-06512: at "SYS.DBMS_SQLDIAG", line 1770
ORA-06512: at line 4


Read more...

Environment

Oracle

Product

SAP NetWeaver all versions

Keywords

ORA-13830, ORA-13829, create_sql_patch, dbms_sqldiag , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.