Saves the specified list of Sqls statements into another Sql tuning set.
POST {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningSets/:sqlTuningSetId/actions/saveAs
Saves the specified list of Sqls statements into another new Sql tuning set or loads into an existing Sql tuning set'.
Request Body
{"name"=>"<string>", "destinationSqlTuningSetName"=>"<string>", "createNew"=>1, "attributeList"=>"TYPICAL", "basicFilter"=>"null", "commitRows"=>0, "credentialDetails"=>{"sqlTuningSetAdminCredentialType"=>"SECRET", "username"=>"<string>", "role"=>"SYSDBA"}, "databaseCredential"=>{"credentialType"=>"PASSWORD"}, "destinationSqlTuningSetDescription"=>"<string>", "destinationSqlTuningSetOwner"=>"null", "isIgnoreNull"=>true, "loadOption"=>"INSERT", "owner"=>"null", "planFilter"=>"null", "rankingMeasure1"=>"null", "rankingMeasure2"=>"null", "rankingMeasure3"=>"null", "recursiveSql"=>"HAS_RECURSIVE_SQL", "resultLimit"=>0, "resultPercentage"=>1, "showSqlOnly"=>0, "updateAttributes"=>nil, "updateCondition"=>nil, "updateOption"=>"REPLACE"}
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"}