Deletes the Sqls in the specified Sql tuning set.

POST {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningSets/:sqlTuningSetId/actions/dropSqlsInSqlTuningSet

Deletes the Sqls in the specified Sql tuning set that matches the filter criteria provided in the basicFilter. If basicFilter criteria is not provided, then entire Sqls in the Sql tuning set is deleted.

Request Body

{"name"=>"<string>", "basicFilter"=>"null", "credentialDetails"=>{"sqlTuningSetAdminCredentialType"=>"PASSWORD", "username"=>"<string>", "role"=>"SYSDBA"}, "databaseCredential"=>{"credentialType"=>"NAMED_CREDENTIAL"}, "owner"=>"null", "showSqlOnly"=>0}

HEADERS

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
opc-retry-tokenstringA token that uniquely identifies a request so it can be retried in case of a timeout or
server error without risk of executing that same action again. Retry tokens expire after 24
hours, but can be invalidated before then due to conflicting operations. For example, if a resource
has been deleted and purged from the system, then a retry of the original creation request
might be rejected.
Content-Typestring
Acceptstring

RESPONSES

status: OK

{&quot;status&quot;:&quot;SUCCEEDED&quot;,&quot;errorCode&quot;:&quot;\u003cinteger\u003e&quot;,&quot;errorMessage&quot;:&quot;\u003cstring\u003e&quot;,&quot;showSqlOnly&quot;:&quot;\u003cinteger\u003e&quot;,&quot;sqlStatement&quot;:&quot;\u003cstring\u003e&quot;,&quot;successMessage&quot;:&quot;\u003cstring\u003e&quot;}