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
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.
SAP Knowledge Base Article - Preview