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?