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
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-retry-token | string | A 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-Type | string | ||
Accept | string |
RESPONSES
status: OK
{"status":"SUCCEEDED","errorCode":"\u003cinteger\u003e","errorMessage":"\u003cstring\u003e","showSqlOnly":"\u003cinteger\u003e","sqlStatement":"\u003cstring\u003e","successMessage":"\u003cstring\u003e"}