Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Idea for DMU: Check for possible ORA-1404 issues when scanning the database

Markus FlechtnerSep 24 2020 — edited Sep 24 2020

Hi,

some time ago I did a database conversion to Unicode (AL32UTF8) with DMU which failed during the database conversion due to an "ORA-01404: ALTER COLUMN will make an index too large".

The reason was obvious:

There was an index which consisted of 4 column with 1000 characters maximum length each and in Unicode this could end up with 4 x 4000 bytes for an index entry which obviously does not fit into an 8K database block.

IMHO DMU could (and should!) check this during the scan phase so that the conversion does not fail but the index design can be reconsidered before starting the conversion.

Regards

Markus

Added on Sep 24 2020

#database-key-features, #database-migration-assistant-for-unicode

3 comments

393 views