ORA-13758: "SQL Tuning Set" "string" owned by user "string" is in use.

Cause : The user attempted to modify a SQL Tuning Set or to add a reference to a SQL Tuning Set which is in use.

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

Wait until the end of the previous operation and retry.

update : 26-05-2017

ORA-13758 - "SQL Tuning Set" "string" owned by user "string" is in use.
ORA-13758 - "SQL Tuning Set" "string" owned by user "string" is in use.

  • ora-07750 : slemcr: fopen failure
  • ora-02822 : Invalid block offset
  • ora-25950 : missing where clause in join index specification
  • ora-01196 : file string is inconsistent due to a failed media recovery session
  • ora-01909 : REUSE keyword expected
  • ora-09321 : slzdtb: unable to convert zoned decimal to binary
  • ora-09886 : osnTXtt: translation error while expanding txipc@.trc.
  • ora-26660 : Invalid action context value for string
  • ora-23477 : unable to alter propagation mode for object group "string"."string"
  • ora-01269 : Destination parameter string is too long
  • ora-34177 : (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.
  • ora-23406 : insufficient privileges on user "string"
  • ora-29800 : invalid name for operator
  • ora-36816 : (XSTBLFUNC09) The workspace object dimension is of datatype string which does not support custom member upserts.
  • ora-40106 : positive target value not specified for computing Lift
  • ora-06258 : NETNTT: cannot allocate context area
  • ora-29880 : such column list already indexed using another domain index and indextype
  • ora-28582 : a direct connection to this agent is not allowed
  • ora-28359 : invalid certificate identifier
  • ora-25292 : Buffer operations are not supported on the queue
  • ora-00324 : log file 'string' translated name 'string' too long, string characters exceeds string limit
  • ora-02808 : Allocation of memory of open files array failed.
  • ora-01774 : Dump undo option specified more than once
  • ora-29918 : cannot create domain indexes on temporary tables
  • ora-27008 : function called with invalid file structure
  • ora-28035 : Cannot Get Session Key for Authentication
  • ora-36642 : (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object.
  • ora-36182 : (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.
  • ora-16012 : Archive log standby database identifier mismatch
  • ora-28272 : Domain policy restricts password based GLOBAL user authentication.
  • 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.