We’re excited to share that CPAT version 26.1.0 is now available as of January 2026.
If you’re not familiar with the tool, you’ll find links at the end of this post to previous articles containing everything you need to know.
One of my favorite additions is the new checks related to Transportable Tablespaces. You can use them when migrating databases across platforms, for example, with the M5 migration script or when using the new TTS method available for migrations to the Autonomous AI Database.
New migration method and new options for tablespaces:
When running XTTS, and not passing the --tablespaces or --excludetablespaces flag, it will default to --tablespaces ALL, which means all permanent tablespaces except SYSTEM and SYSAUX.
Let’s create some data to test it:
create tablespace tbs_data;
create tablespace tbs_index;
create tablespace tbs_data2;
create user az identified by mysuperpasswd;
grant dba to az;
create table az.sales (c1 number) tablespace tbs_data;
create table az.orders (c1 number) tablespace tbs_data2;
create index az.i_orders on az.orders (c1) tablespace tbs_index;Let’s run CPAT and not add the TBS_DATA2:
Checking the results:
What is new in CPAT
This is the list of new features and fixes in CPAT 26.1.0.
Recently Added Features and Enhancements:
OPTD-797: Added check has_workspaces to check if Oracle Workspace Manager is
being used. Extra steps need to be taken to properly migrate in such cases.
OPTD-815: Added new migration method XTTS so CPAT can help check the viability of a cross-platform TTS migration (specific to the M5 script method).
OPTD-831: The keystore functionality available in Linux has been expanded to
Windows.
OPTD-833: Running CPAT in CDB mode will now run in schema mode by default. To
run in full mode, the parameter will need to be used explicitly.
OPTD-842: Revised text for the has_columns_with_media_data_types_adb check.
OPTD-843: Added functionality to filter checks by specific objects
OPTD-844: Added parameter --enlang to force reports to be in English
regardless of Locale settings.
OPTD-848: Added functionality for a SCHEMA_MODE_PLUS as requested by ZDM.
Recently Fixed Bugs or Other Changes:
OPTD-841: Fixed issue where the new HTML_OFFLINE report and dependencies where not being added to the zip file when using --zip.
OPTD-834: System users where complement with a list of users whi are not
marked as Oracle maintained, but are known to be system users.
OPTD-841 Fixed an issue when trying to overwrite existing files using
the HTML_OFFLINE option. Also, dependencies are now added properly to the zip file when using the --zip parameter.
Links to the Complete Blog Post Series about CPAT:
- FAQ
- Part 1 – Starting with CPAT
- Part 2 – Options for Running CPAT
- Part 3 – Running CPAT
- Part 4 – Troubleshooting CPAT
- Part 5 – CPAT Checks
- Part 6 – CPAT New Features – December 2024
- Part 7 – Cloud Premigration Advisor Tool (CPAT) Composer
- Part 8 – CPAT New Features – June 2025
- Part 9 – CPAT – How to Use a Parameter File
- Part 10 – CPAT New Features – September 2025
- Part 11 – CPAT New Features – December 2025
- Part 12 – CPAT New Features – January 2026