Causes of frequent ORA-01460 errors in PL/SQL developer

Source: Internet
Author: User
When you use PL/SQL developer 7 to connect to a newly installed Oracle database server, ORA-01460 errors always occur frequently: type conversion errors.
Only PL/SQL developer has this problem.

The suspect is a character set problem. I checked a lot of information and found the cause of the problem:
Query select * From nls_database_parameters, view the nls_characterset item, and find that the character set on the normal database server is zhs16cgb231280, and the character set on the problematic server is zhs32gb18030.

An error occurred while trying to use the following command to modify the character set:
Shutdown immedaite;
Startup nomount;
Alter database Mount exclusive;
Alter system enable restricted session;
Alter system set job_queue_process = 0; -- execute this statement and report an error.
Alter database open;
Alter database character set zhs16cgb231280; -- execute this statement to allow only modification to the superset

It seems that only a new database can be installed. Who has a better solution?
 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.