Class SubsetDataDetails.Builder

    • Constructor Detail

      • Builder

        public Builder()
    • Method Detail

      • targetId

        public SubsetDataDetails.Builder targetId​(String targetId)
        The OCID of the target database to be subsetted.

        If it’s not provided, the value of the targetId attribute in the SubsettingPolicy resource is used

        Parameters:
        targetId - the value to set
        Returns:
        this builder
      • isRerun

        public SubsetDataDetails.Builder isRerun​(Boolean isRerun)
        Indicates if the request is to rerun the previously failed subsetting job
        Parameters:
        isRerun - the value to set
        Returns:
        this builder
      • reRunFromStep

        public SubsetDataDetails.Builder reRunFromStep​(SubsetDataDetails.ReRunFromStep reRunFromStep)
        Specifies the step from which subsetting needs to be rerun.

        This param will be used only when isRerun attribute is true. If PRE_SUBSETTING_SCRIPT is passed, it will rerun the pre-subsetting script, followed by subsetting, and then the post-subsetting script. If POST_SUBSETTING_SCRIPT is passed, it will rerun only the post-subsetting script. If this field is not set and isRerun is set to true, then it will default to the last failed step.

        Parameters:
        reRunFromStep - the value to set
        Returns:
        this builder
      • tablespace

        public SubsetDataDetails.Builder tablespace​(String tablespace)
        The tablespace that should be used to create the temporary tables for data subsetting.

        If no tablespace is provided, the DEFAULT tablespace is used.

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

        public SubsetDataDetails.Builder isRedoLoggingEnabled​(Boolean isRedoLoggingEnabled)
        Indicates if redo logging is enabled during a subsetting operation.

        Set this attribute to true to enable redo logging. If set as false, 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, you could enable logging and use a flashback database to retrieve the original data after it has been subsetted. If it’s not provided, the value of the isRedoLoggingEnabled attribute in the SubsettingPolicy resource is used.

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

        public SubsetDataDetails.Builder isRefreshStatsEnabled​(Boolean isRefreshStatsEnabled)
        Indicates if statistics gathering is enabled.

        Set this attribute to false to disable statistics gathering. The subsetting process gathers statistics on subset database tables after subsetting completes. If it’s not provided, the value of the isRefreshStatsEnabled attribute in the SubsettingPolicy resource is used.

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

        public SubsetDataDetails.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. https://www.oracle.com/pls/topic/lookup?ctx=dblatest&en/database/oracle/oracle-database&id=VLDBG-GUID-3E2AE088-2505-465E-A8B2-AC38813EA355 If it’s not provided, the value of the parallelDegree attribute in the SubsettingPolicy resource is used.

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

        public SubsetDataDetails.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. If it’s not provided, the value of the recompile attribute in the SubsettingPolicy resource is used.

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