ORA-13830: SQL profile with category string already exists for this SQL statement

Cause : A SQL profile already exists for the given SQL statement and category.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Drop or update the existing SQL profile.

update : 23-08-2017
ORA-13830

ORA-13830 - SQL profile with category string already exists for this SQL statement
ORA-13830 - SQL profile with category string already exists for this SQL statement

  • ora-36718 : (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.
  • ora-15185 : Could not close dynamic library string, error [string]
  • ora-36815 : (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.
  • ora-27084 : unable to get/set file status flags
  • ora-12657 : No algorithms installed
  • ora-36702 : (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.
  • ora-14026 : PARTITION and CLUSTER clauses are mutually exclusive
  • ora-30083 : syntax error was found in interval value expression
  • ora-08265 : create_ora_addr: cannot open nameserver
  • ora-02878 : sou2o: Variable smpdidini overwritten
  • ora-03126 : network driver does not support non-blocking operations
  • ora-39307 : operation is illegal without an initial clone
  • ora-29900 : operator binding does not exist
  • ora-32806 : value for string is too long, maximum length is string
  • ora-14008 : missing THAN keyword
  • ora-19375 : no CREATE TABLE privilege on schema "string"
  • ora-25292 : Buffer operations are not supported on the queue
  • ora-13832 : category name specified is invalid
  • ora-01105 : mount is incompatible with mounts by other instances
  • ora-13611 : The command string is not a valid advisor command.
  • ora-28110 : policy function or package string.string has error
  • ora-39055 : The string feature is not supported in version string.
  • ora-16534 : no more requests accepted
  • ora-12014 : table 'string' does not contain a primary key constraint
  • ora-02145 : missing STORAGE option
  • ora-30192 : reserved for future use
  • ora-01208 : data file is an old version - not accessing current version
  • ora-01274 : cannot add datafile 'string' - file could not be created
  • ora-02007 : can't use ALLOCATE or DEALLOCATE options with REBUILD
  • ora-12223 : TNS:internal limit restriction exceeded
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.