Today is very strange, import a single table to report the error of ORA-01401, also searched a circle online, and my situation is different. This error occurs because the characters stored in the exported dmp file are different in bytes. My database is 11g11. 2.0.1.0, the default choice is ZHS16GBK encoding method, to import is the school 10g Database Export backup of A dmp file, and finally can not solve the problem according to a ORA-12899 error.
The procedure is as follows:
SQL> shutdown immediate
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 1006636376 bytes
Database Buffers 637534208 bytes
Redo Buffers 7118848 bytes
Database mounted.
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
System altered.
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 0;
System altered.
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES = 0;
System altered.
SQL> ALTER DATABASE OPEN;
Database altered.
SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;
Database altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 1006636376 bytes
Database Buffers 637534208 bytes
Redo Buffers 7118848 bytes
Database mounted.
Database opened.
SQL>
The client is successfully imported.
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian