Class CreateSubsettingPolicyDetails

Details to create a new subsetting policy. Use either a sensitive data model or a target database as the source of schemas for subsetting. To use a sensitive data model as the source of schemas, set the schemaSource attribute to SENSITIVE_DATA_MODEL and provide the sensitiveDataModelId attribute. The schemas from the SDM will be used for subsetting. To use a target database as the source of schemas, set the schemaSource attribute to TARGET and provide the targetId attribute along with the schemasForSubsetting list. The schema list can also be provided or updated later using the UpdateSubsettingPolicy operation. After creating a subsetting policy, you can use operations to add or modify subsetting rules as needed

Inheritance

object

CreateSubsettingPolicyDetails

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DatasafeService.Models

Assembly: OCI.DotNetSDK.Datasafe.dll

Syntax

public class CreateSubsettingPolicyDetails

Properties

CompartmentId

Declaration

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

Property Value

Type	Description
string	The OCID of the compartment where the subsetting policy should be created

Remarks

Required

DefinedTags

Declaration

[JsonProperty(PropertyName = "definedTags")]
public Dictionary<string, Dictionary<string, object>> DefinedTags { get; set; }

Property Value

Type	Description
Dictionary<string, Dictionary<string, object>>	Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations": {"CostCenter": "42"}}

Description

Declaration

[JsonProperty(PropertyName = "description")]
public string Description { get; set; }

Property Value

Type	Description
string	The description of the subsetting policy

DisplayName

Declaration

[JsonProperty(PropertyName = "displayName")]
public string DisplayName { get; set; }

Property Value

Type	Description
string	The display name of the subsetting policy. The name does not have to be unique, and it's changeable

FreeformTags

Declaration

[JsonProperty(PropertyName = "freeformTags")]
public Dictionary<string, string> FreeformTags { get; set; }

Property Value

Type	Description
Dictionary<string, string>	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"}

IsRedoLoggingEnabled

Declaration

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

Property Value

Type	Description
bool?	Indicates if redo logging is enabled during a subsetting operation. It's disabled by default. Set this attribute to true to enable redo logging. By default, subsetting disables redo logging and flashback logging to purge any original data from logs. However, in certain circumstances when you only want to test subsetting, rollback changes, and retry subsetting, you could enable logging and use a flashback database to retrieve the original data after it has been subsetted

Type

Description

bool?

Indicates if redo logging is enabled during a subsetting operation. It's disabled by default. Set this attribute to true to enable redo logging. By default, subsetting disables redo logging and flashback logging to purge any original data from logs. However, in certain circumstances when you only want to test subsetting, rollback changes, and retry subsetting, you could enable logging and use a flashback database to retrieve the original data after it has been subsetted

IsRefreshStatsEnabled

Declaration

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

Property Value

Type	Description
bool?	Indicates if statistics gathering is enabled. It's enabled by default. Set this attribute to false to disable statistics gathering. The subsetting process gathers statistics on subsetted database tables after subsetting completes

MaskingPolicyId

Declaration

[JsonProperty(PropertyName = "maskingPolicyId")]
public string MaskingPolicyId { get; set; }

Property Value

Type	Description
string	The OCID of the masking policy to associate with this subsetting policy

ParallelDegree

Declaration

[JsonProperty(PropertyName = "parallelDegree")]
public string ParallelDegree { get; set; }

Property Value

Type	Description
string	Specifies options to enable parallel execution when running data subsetting. Allowed values are 'NONE' (no parallelism), 'DEFAULT' (the Oracle Database computes the optimum degree of parallelism) or an integer value to be used as the degree of parallelism. Parallel execution helps effectively use multiple CPUs and improve subsetting performance. Refer to the Oracle Database parallel execution framework when choosing an explicit degree of parallelism

Type

Description

string

Specifies options to enable parallel execution when running data subsetting. Allowed values are 'NONE' (no parallelism), 'DEFAULT' (the Oracle Database computes the optimum degree of parallelism) or an integer value to be used as the degree of parallelism. Parallel execution helps effectively use multiple CPUs and improve subsetting performance. Refer to the Oracle Database parallel execution framework when choosing an explicit degree of parallelism

PostSubsettingScript

Declaration

[JsonProperty(PropertyName = "postSubsettingScript")]
public string PostSubsettingScript { get; set; }

Property Value

Type	Description
string	A post-subsetting script, which can contain SQL and PL/SQL statements. It's executed after the subsetting process. It's usually used to perform additional transformation or cleanup work after subsetting data.

PreSubsettingScript

Declaration

[JsonProperty(PropertyName = "preSubsettingScript")]
public string PreSubsettingScript { get; set; }

Property Value

Type	Description
string	A pre-subsetting script, which can contain SQL and PL/SQL statements. It's executed before the subsetting process. It's usually used to perform any preparation or prerequisite work before subsetting data.

Recompile

Declaration

[JsonProperty(PropertyName = "recompile")]
[JsonConverter(typeof(StringEnumConverter))]
public SubsettingPolicy.RecompileEnum? Recompile { get; set; }

Property Value

Type	Description
SubsettingPolicy.RecompileEnum?	Specifies how to recompile invalid objects post data subsetting. Allowed values are 'SERIAL' (recompile in serial), 'PARALLEL' (recompile in parallel), 'NONE' (do not recompile). If it's set to PARALLEL, the value of parallelDegree attribute is used. Use the built-in UTL_RECOMP package to recompile any remaining invalid objects after subsetting completes

SchemaSource

Declaration

[Required(ErrorMessage = "SchemaSource is required.")]
[JsonProperty(PropertyName = "schemaSource")]
public CreateSchemaSourceDetails SchemaSource { get; set; }

Property Value

Type	Description
CreateSchemaSourceDetails

Remarks

Required

UnrelatedTablesAction

Declaration

[JsonProperty(PropertyName = "unrelatedTablesAction")]
[JsonConverter(typeof(StringEnumConverter))]
public SubsettingPolicy.UnrelatedTablesActionEnum? UnrelatedTablesAction { get; set; }

Property Value

Type	Description
SubsettingPolicy.UnrelatedTablesActionEnum?	Strategy to be applied for tables which are not impacted by any of the subsetting rules