Class Datafile

The details of a data file.

Inheritance

object

Datafile

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DatabasemanagementService.Models

Assembly: OCI.DotNetSDK.Databasemanagement.dll

Syntax

public class Datafile

Properties

AllocatedSizeKB

Declaration

[JsonProperty(PropertyName = "allocatedSizeKB")]
public decimal? AllocatedSizeKB { get; set; }

Property Value

Type	Description
decimal?	The allocated file size in KB.

FreeSpaceKB

Declaration

[JsonProperty(PropertyName = "freeSpaceKB")]
public decimal? FreeSpaceKB { get; set; }

Property Value

Type	Description
decimal?	The free space available in the data file in KB.

IncrementBy

Declaration

[JsonProperty(PropertyName = "incrementBy")]
public decimal? IncrementBy { get; set; }

Property Value

Type	Description
decimal?	The number of blocks used as auto-extension increment.

InstanceId

Declaration

[JsonProperty(PropertyName = "instanceId")]
public decimal? InstanceId { get; set; }

Property Value

Type	Description
decimal?	Instance ID of the instance to which the temp file belongs. This column has a NULL value for temp files that belong to shared tablespaces.

IsAutoExtensible

Declaration

[JsonProperty(PropertyName = "isAutoExtensible")]
public bool? IsAutoExtensible { get; set; }

Property Value

Type	Description
bool?	Indicates whether the data file is auto-extensible.

LostWriteProtect

Declaration

[JsonProperty(PropertyName = "lostWriteProtect")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Datafile.LostWriteProtectEnum? LostWriteProtect { get; set; }

Property Value

Type	Description
Datafile.LostWriteProtectEnum?	The lost write protection status of the file.

MaxSizeKB

Declaration

[JsonProperty(PropertyName = "maxSizeKB")]
public decimal? MaxSizeKB { get; set; }

Property Value

Type	Description
decimal?	The maximum file size in KB.

Name

Declaration

[Required(ErrorMessage = "Name is required.")]
[JsonProperty(PropertyName = "name")]
public string Name { get; set; }

Property Value

Type	Description
string	The filename (including the path) of the data file or temp file.

Remarks

Required

OnlineStatus

Declaration

[JsonProperty(PropertyName = "onlineStatus")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Datafile.OnlineStatusEnum? OnlineStatus { get; set; }

Property Value

Type	Description
Datafile.OnlineStatusEnum?	The online status of the file.

Shared

Declaration

[JsonProperty(PropertyName = "shared")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Datafile.SharedEnum? Shared { get; set; }

Property Value

Type	Description
Datafile.SharedEnum?	Type of tablespace this file belongs to. If it's for a shared tablespace, for a local temporary tablespace for RIM (read-only) instances, or for local temporary tablespace for all instance types.

Status

Declaration

[JsonProperty(PropertyName = "status")]
[JsonConverter(typeof(ResponseEnumConverter))]
public Datafile.StatusEnum? Status { get; set; }

Property Value

Type	Description
Datafile.StatusEnum?	The status of the file. INVALID status is used when the file number is not in use, for example, a file in a tablespace that was removed.

UsedPercentAllocated

Declaration

[JsonProperty(PropertyName = "usedPercentAllocated")]
public double UsedPercentAllocated { get; set; }

Property Value

Type	Description
double	The percentage of used space out of the total allocated space in the file.

UsedPercentAvailable

Declaration

[JsonProperty(PropertyName = "usedPercentAvailable")]
public double UsedPercentAvailable { get; set; }

Property Value

Type	Description
double	The percentage of used space out of the maximum available space in the file.

UsedSpaceKB

Declaration

[JsonProperty(PropertyName = "usedSpaceKB")]
public decimal? UsedSpaceKB { get; set; }

Property Value

Type	Description
decimal?	The total space used in the data file in KB.

UserSizeKB

Declaration

[JsonProperty(PropertyName = "userSizeKB")]
public decimal? UserSizeKB { get; set; }

Property Value

Type	Description
decimal?	The size of the file available for user data in KB. The actual size of the file minus the USER_BYTES value is used to store file-related metadata.