Oracle Importing DMP Files

Command:

IMP database user name/password @127.0.0.1:1521/orcl file=d:\txpt20150424.dmp full=y

If the above command appears with the following error message

IMP-00058: Encountering ORACLE error 12514
Ora-12514:tns: Listener currently does not recognize the requested service in the connection descriptor
IMP-00000: Failed to terminate import successfully

Use the following statement to import

IMP database user name/password full=y file= d:\txpt20150424.dmp ignore=y

If you encounter the following error during the import process:

I MP-00019: Deny row due to ORACLE error 12899
IMP-00003: Encountering ORACLE error 12899
ORA-12899: Column "Jackeyj". " Jk_register "." Opname "value is too large (actual value: 21, Maximum: 20)

Workaround:

Modifying the character set of Oracle 10g
Oracle
Modify the database character set to: ZHS16GBK
Viewing the server-side character set

SQL > select * from V$nls_parameters

Modify:

$sqlplus/nologsql>conn/as SYSDBA

If the database server is now started, execute the SHUTDOWN IMMEDIATE command to shut down the database server.
Then execute the following command:

Sql>shutdown immediatesql>startup mountsql>alter System ENABLE RESTRICTED sessionsql>alter system SET job_ Queue_processes=0sql>alter SYSTEM SET aq_tm_processes=0sql>alter database opensql>alter database CHARACTER SET ZHS16GBK

ERROR at line 1 ra-12721:operation cannot execute when other sessions is active
If the above error occurs, use the following method to modify, using Internal_use can skip the check of the superset:

Sql>alter DATABASE CHARACTER SET internal_use zhs16gbksql>shutdown immediatesql>startup

After executing the above command, the Guide statement is re-executed.

Oracle Import DMP files