Smart partitioning supports Oracle 12c as a source connection type.

You can update the SQL text and the job status of a job step from the

Monitor Jobs

page. For example, you can change the job status from "ERROR" to "COMPLETED" so that a statement will not run again. To modify a status, the job status cannot be "RUNNING" and the task status cannot be "COMPLETED."

The Unpartition Tables standalone job replaces all of the segmented tables in a segmentation group with the original, unsegmented tables.

The Copy Source Metadata standalone job copies the metadata from one ILM repository to another ILM repository on a cloned source connection.

You can review the explain plan for a segmentation group from the

Monitor Jobs

page. To review the explain plan in the job details on the Monitor Jobs page, you must enable a SESSION type segmentation parameter called "statistics_level."

Smart partitioning supports Oracle Hybrid Columnar Compression. You can enable Oracle Hybrid Columnar Compression when you create a storage classification.

On Oracle 12c source connections, you can enable the "hide_partition_key_column" segmentation parameter to make the partition key column invisible.

When you move a segment to another storage classification in an Oracle 12c database, the job uses online datafile movement.

Smart partitioning supports application servers in multi-node Oracle Real Application clusters.