in the process of using Oracle, there are all sorts of problems, all sorts of bugs, and ORA-12899 is the problem I've been having when I imported data into my local machine. But fortunately has solved this problem, now share, the solution;
appears ORA-12899, is caused by the character set, Chinese in UTF-8 accounted for 3 bytes, zhs16gbk accounted for 2 bytes, and the source DMP file character set is the ZHS16GBK library of the data poured out, now to import to the target character set for UTF-8 library, So there will be ORA-12899 .
in fact, as long as the revision of Oracle's character set can be a good solution to this problem;
But when I changed the character set, I found that I had forgotten the password for the SYS account, which was a tragedy, so I had to modify the SYS user's password first.
changes in the password is also divided into several cases, I will list the following:
Forget the login password for users other than SYS and system users.
Log on with the SYS (or system) user.
CONN Sys/pass_word as SYSDBA;
Use the following statement to modify the user's password.
ALTER USER user_name identified by Newpass;
Note: Passwords cannot be all numbers. and cannot be the beginning of a number. Otherwise, it will appear: ORA-00988: Password missing or invalid
The forgotten sys user, or the password of the system user.
If you are forgetting the password for the system user, you can log in with the SYS user. Then use the Alter USER's
Modify the password.
CONN Sys//pass_word as SYSDBA;
ALTER USER SYSTEM identified by Newpass;
If you are forgetting the password for the SYS user, you can log on with the system user. Then use the Alter USER's
Modify the password.
CONN System//pass_word;
ALTER USER SYSTEM identified by Newpass;
If the password of the Sys,system user is forgotten or lost.
This is particularly important.
You can use the ORAPWD.EXE tool to modify your password.
Start Menu-> Run-> enter ' CMD ', open a Command Prompt window, enter the following command:
Orapwd File=d:/oracle/product/10.2.0/db_1/database/pwdctcsys.ora
Password=newpass
This command regenerates the password file for the database. The location of the password file is in the Oracle_home directory
In the/database directory.
This password is the password that modifies the SYS user. Passwords for other users except SYS and system will not change.
after the password has been modified, it can be modified as a DBA, not the DBA's ability to prompt you for insufficient permissions when executing the change command.
start--> Run-->cmd, and then enter: "Sqlplus SYS/ORACLE@192.168.0.1/ORCL as SYSDBA "
If you do not enter the normal, it will require you to manually enter the username and password, will appear after entering
"sql>" Tips,
Follow the commands given below to perform them sequentially.
Sql>shutdown IMMEDIATE
Sql>startup MOUNT
Sql>alter SYSTEM ENABLE restricted session;
Sql>alter SYSTEM SET job_queue_processes=0;
Sql>alter SYSTEM SET aq_tm_processes=0;
Sql>alter DATABASE OPEN;
sql> ALTER DATABASE CHARACTER SET ZHS16GBK;
ALTER DATABASE CHARACTER SET ZHS16GBK
*error at line 1:
Ora-12712:new Character set must is a superset of old character set
The internal_use command does not check the character set superset when the character set is not compatible:
sql>alter DATABASE CHARACTER SET internal_use ZHS16GBK;
Sql>shutdown IMMEDIATE
Sql>startup
at this time, this ORA-12899 has been completely resolved, you can import the data ...
