An IMP import data from Oracle Error: Ora-12592:tns: Package Errors

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.

Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/43153127

When importing data using IMP, check that the table that found Sambadovan data actually imports only alligators data, check the import log, the following error message,

Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit productionwith The partitioning, Real application C Lusters, Automatic Storage Management, Olap,data Mining and Real application tes the export file created by export:v11.02.00 through the regular path has been completed ZHS16 Import in the GBK character set and Al16utf16 NCHAR character set. Importing HYL objects into HYL. . Importing table                   "Tb_hyl_ws" ......................................................................................................................... ........................................................ IMP-00058: Encountered ORACLE error 12592ORA-12592:TNS: Package error IMP-00018: Partial import of previous table completed: Imported 1772044 rows successfully terminated the import, but a warning appears.

After checking, through the TNS error information point, suspected network problems, the import machine to connect through the client, and then use the Xmanager software to upload the DMP file to the server, re-execute IMP Import command, successfully import the table, view the log information as follows:

Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit productionwith The partitioning, OLAP, Dat A Mining and Real application testing Optionsexport file created by export:v11.02.00 via conventional pathimport do in Z HS16GBK character set and Al16utf16 NCHAR character set. Importing HYL ' s objects into HYL. . Importing table                  "Tb_hyl_ws"    3701686 rows Importedimport terminated successfully without warnings.

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.

Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/43153127

An IMP import data from Oracle Error: Ora-12592:tns: Package Errors