Issue
When using Oracle 19c as the database, setting the compatible version to 12.1.0.2 or lower can lead to errors under certain circumstances, such as when publishing an object that has relationships with others.
You can verify the current compatible version by running the following query:
SELECT name, value
FROM v$parameter
WHERE name = 'compatible';
The primary cause of this issue is documented in the official Oracle documentation. In Oracle Database versions prior to 12.2, the maximum length for identifier names, such as table names, column names, and primary key names is limited to 30 characters. Starting with Oracle Database 12.2, this limit has been increased to 128 characters by default.
Environment
- Quarterly Releases
Resolution
Given that the upgrade from 12.1.0.2 to 12.2 is a minor version change, a recommended solution is to adjust the compatibility level to 12.2.