Data Source: oci_database_oneoff_patches

This data source provides the list of Oneoff Patches in Oracle Cloud Infrastructure Database service.

Lists one-off patches in the specified compartment.

Example Usage

data "oci_database_oneoff_patches" "test_oneoff_patches" {
	#Required
	compartment_id = var.compartment_id

	#Optional
	display_name = var.oneoff_patch_display_name
	state = var.oneoff_patch_state
}

Argument Reference

The following arguments are supported:

• compartment_id - (Required) (Updatable) The compartment OCID.
• display_name - (Optional) A filter to return only resources that match the entire display name given. The match is not case sensitive.
• state - (Optional) A filter to return only resources that match the given lifecycle state exactly

Attributes Reference

The following attributes are exported:

• oneoff_patches - The list of oneoff_patches.

OneoffPatch Reference

The following attributes are exported:

• compartment_id - The OCID of the compartment.
• db_version - A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.
• defined_tags - Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
• display_name - One-off patch name.
• freeform_tags - Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}
• id - The OCID of the one-off patch.
• lifecycle_details - Detailed message for the lifecycle state.
• one_off_patches - List of one-off patches for Database Homes.
• release_update - The PSU or PBP or Release Updates. To get a list of supported versions, use the ListDbVersions operation.
• sha256sum - SHA-256 checksum of the one-off patch.
• size_in_kbs - The size of one-off patch in kilobytes.
• state - The current state of the one-off patch.
• system_tags - System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.
• time_created - The date and time one-off patch was created.
• time_of_expiration - The date and time until which the one-off patch will be available for download.
• time_updated - The date and time one-off patch was updated.