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 : 24-09-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-33338 : (DSSEXIST05) You cannot specify the EXPTEMP analytic workspace.
  • ora-25230 : invalid value string, WAIT should be non-negative
  • ora-32134 : Cannot assign LOBs
  • ora-12703 : this character set conversion is not supported
  • ora-02085 : database link string connects to string
  • ora-01606 : gc_files_to_locks not identical to that of another mounted instance
  • ora-23381 : generated object for base object string.string@string does not exist
  • ora-32110 : Connection not specified
  • ora-28521 : no heterogeneous capability information available
  • ora-40001 : value for string must be greater than zero
  • ora-03299 : cannot create dictionary table string
  • ora-37143 : (XSSQLMDQ03) string is not a valid analytic workspace name.
  • ora-25403 : could not reconnect
  • ora-24911 : Cannot start listener thread at specified port
  • ora-01575 : timeout waiting for space management resource
  • ora-02839 : Sync of blocks to disk failed.
  • ora-08309 : sllfop: Cannot fstat file
  • ora-19768 : USING clause only valid with ENABLE CHANGE TRACKING
  • ora-12354 : secondary object being dropped
  • ora-02152 : Invalid ALTER TABLESPACE ... RENAME option
  • ora-14120 : incompletely specified partition bound for a DATE column
  • ora-01198 : must specify size for log file if RESETLOGS
  • ora-03274 : both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified
  • ora-24058 : cannot downgrade QUEUE_TABLE that has propagation in a prepared state
  • ora-00233 : copy control file is corrupt or unreadable
  • ora-28580 : recursive external procedures are not supported
  • ora-30045 : No undo tablespace name specified
  • ora-22634 : Error adding new instance to AnyDataSet
  • ora-19102 : XQuery string literal expected
  • ora-02830 : Segment could not be split - no free segments available
  • 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.