Site icon IT Tutorial

ORA-13841: SQL profile named already exists for a different signature/category pair

I got ” ORA-13841: SQL profile named already exists for a different signature/category pair” error in Oracle database.

 

ORA-13841: SQL profile named already exists for a different signature/category pair

 

Details of error are as follows.

Description: SQL profile named string already exists for a different signature/category pair
Cause: A SQL profile already exists with the name specified under a different signature/category pair so it cannot be replaced, even with FORCE specified.
Action: Specify a different name or drop the existing SQL profile.

 

 

The ORA-13841 error is related with the existing SQL Profile for the different signature/category pair.

 

ORA-13841

To solve this error, you should drop the existing SQL Profile as follows.

 

Firstly list the existing SQL Profiles.

 

List the SQL Profiles.

SQL> select * from dba_sql_profiles;

Find your related SQL Profiles, then drop it as follows.

 

Drop SQL Profile

Then drop the SQL Profile as follows.

BEGIN
DBMS_SQLTUNE.DROP_SQL_PROFILE(name => 'my_sql_profile');
END;
/

 

 

 

 

Do you want to learn Oracle Performance Tuning, then Click This Link and read the articles.

What is the Automatic SQL Tuning and How to Automated SQL Tuning in Oracle | Oracle Database Performance Tuning Tutorial -12

Exit mobile version