This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,853 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

How to stop or cancel a character set conversion process in DMU

I am getting the error "ORA-01404 - Alter column will make an index too large" for some columns.

Dropped the unique constraint of one of these indexes and was able to drop the index so the character set conversion will continue.

The problem is that the conversion process keeps running and have not been able to stop it, so I can restart from the pre-conversion steps.

Exit DMU and reenter several times but the only options I get are to resume the conversion or disconnect. Even brought down the db.

I understand that if I am able to re-start the conversion process, it will recognize the changes I made to the indexes.

Any help is appreciated.


Thanks.