Class SubsettingPolicy.Builder

    • Constructor Detail

      • Builder

        public Builder()
    • Method Detail

      • compartmentId

        public SubsettingPolicy.Builder compartmentId​(String compartmentId)
        The OCID of the compartment that contains the subsetting policy
        Parameters:
        compartmentId - the value to set
        Returns:
        this builder
      • displayName

        public SubsettingPolicy.Builder displayName​(String displayName)
        The display name of the subsetting policy
        Parameters:
        displayName - the value to set
        Returns:
        this builder
      • timeCreated

        public SubsettingPolicy.Builder timeCreated​(Date timeCreated)
        The date and time the subsetting policy was created, in the format defined by RFC3339
        Parameters:
        timeCreated - the value to set
        Returns:
        this builder
      • timeUpdated

        public SubsettingPolicy.Builder timeUpdated​(Date timeUpdated)
        The date and time the subsetting policy was last updated, in the format defined by RFC3339
        Parameters:
        timeUpdated - the value to set
        Returns:
        this builder
      • description

        public SubsettingPolicy.Builder description​(String description)
        The description of the subsetting policy
        Parameters:
        description - the value to set
        Returns:
        this builder
      • isRedoLoggingEnabled

        public SubsettingPolicy.Builder isRedoLoggingEnabled​(Boolean isRedoLoggingEnabled)
        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.

        Parameters:
        isRedoLoggingEnabled - the value to set
        Returns:
        this builder
      • isRefreshStatsEnabled

        public SubsettingPolicy.Builder isRefreshStatsEnabled​(Boolean isRefreshStatsEnabled)
        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 database tables after subsetting completes

        Parameters:
        isRefreshStatsEnabled - the value to set
        Returns:
        this builder
      • parallelDegree

        public SubsettingPolicy.Builder parallelDegree​(String parallelDegree)
        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

        Parameters:
        parallelDegree - the value to set
        Returns:
        this builder
      • recompile

        public SubsettingPolicy.Builder recompile​(SubsettingPolicy.Recompile recompile)
        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

        Parameters:
        recompile - the value to set
        Returns:
        this builder
      • preSubsettingScript

        public SubsettingPolicy.Builder preSubsettingScript​(String preSubsettingScript)
        A pre-subsetting script, which can contain SQL and PL/SQL statements.

        It’s executed before the core subsetting script generated using the subsetting policy. It’s usually used to perform any preparation or prerequisite work before subsetting data

        Parameters:
        preSubsettingScript - the value to set
        Returns:
        this builder
      • postSubsettingScript

        public SubsettingPolicy.Builder postSubsettingScript​(String postSubsettingScript)
        A post-subsetting script, which can contain SQL and PL/SQL statements.

        It’s executed after the core subsetting script generated using the subsetting policy. It’s usually used to perform additional transformation or cleanup work after subsetting.

        Parameters:
        postSubsettingScript - the value to set
        Returns:
        this builder
      • maskingPolicyId

        public SubsettingPolicy.Builder maskingPolicyId​(String maskingPolicyId)
        The OCID of the masking policy associated with this subsetting policy
        Parameters:
        maskingPolicyId - the value to set
        Returns:
        this builder
      • freeformTags

        public SubsettingPolicy.Builder freeformTags​(Map<String,​String> freeformTags)
        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"}

        Parameters:
        freeformTags - the value to set
        Returns:
        this builder
      • definedTags

        public SubsettingPolicy.Builder definedTags​(Map<String,​Map<String,​Object>> definedTags)
        Defined tags for this resource.

        Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {“Operations”: {“CostCenter”: “42”}}

        Parameters:
        definedTags - the value to set
        Returns:
        this builder