Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What should I do if I receive the error “ORA-22866: default character set is of varying width” when migrating to a destination Oracle database created with the UTF8 character set?

April 26, 2017character Default destination Error migrating oracle database varying

0

Posted

What should I do if I receive the error “ORA-22866: default character set is of varying width” when migrating to a destination Oracle database created with the UTF8 character set?

1 Answer

0

Posted

To overcome this problem, do one of the following: Migrate to an Oracle9i database. If you are migrating to an Oracle8i database, set the COMPATIBLE initialization parameter as follows: compatible=8.1.0.