ORACLE11g IMP-00058

ORACLE11g IMP-00058 problem today, the boss gave me a task to put four. the dmp file is imported into the oracle10G Database. I installed the 11G database on my local machine. If I didn't want it, I would just export it. Use the import table function in PLSQL Developer to export data. Www.2cto.com 1. create a tablespace, create a user, and assign permissions. tablespace: [SQL] create tablespace GPORTAL logging datafile 'C: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ GPORTAL. dbf 'size 50 m autoextend on next 50 m maxsize 20480 m extent management local; user: www.2cto.com [SQL] create user czportal identified by a12345 default tablespace GPORTAL TEMPORARY TABLESPACE TEMP; permission: [SQL] grant connect, resource, dba to czportal; 2, okay! Data Import started. Run PLSQL Developer or IMP Command [SQL] imp czportal/a12345@192.168.0.23: 1521/orcl file = c: \ dmp \ czportal130311.dmp log = c: \ dmp \ czportal130312.log full = y ignore = y error. IMP-00058: An ORACLE error occurs. 942ORA-00942: the table or view does not have 0 rows imported. [SQL] connection: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production With the Partitioning, OLAP and Data Mining options the import server in the ZHS16GBK Character Set and AL16UTF16 NCHAR character set has been used by the EXPORT File Created by EXPORT: V10.02.01 in the general path to use the AL32UTF8 character set (possible Character Set conversion ). importing the GCR object to GCR .. importing table "CMS_FILTER" to 0 rows .. importing table "DS_BACKUP" to 0 rows .. importing table "DS_BKCFG" 0 Line .. importing table "DS_INDEX" to 0 rows .. importing table "DS_LEXICON" to 0 rows .. importing table "DS_LOG" into three rows .. importing the table "FILTER" to 0 rows .. importing table "PM61_DEFAULT_BINVAL" IMP-00058: encountered ORACLE error 942 ORA-00942: Table or view does not exist importing 0 rows .. importing table "PM61_DEFAULT_BUNDLE" IMP-00058: encountered ORACLE error 942 ORA-00942: Table or view does not exist importing 4144 rows .. importing table "PM61_DEFAULT_NAMES" to 0 rows .. importing table "PM61_DEFAULT_REFS" IMP-00058: encountered ORACLE error 942 ORA-00942: Table or view not 0 rows imported .. importing table "PM61_SECURITY_BINVAL" IMP-00058: encountered ORACLE error 942 ORA-00942: Table or view does not exist importing 0 rows .. importing table "PM61_SECURITY_BUNDLE" IMP-00058: encountered ORACLE error 942 ORA-00942: Table or view does not exist importing 10 rows .. importing the table "PM61_SECURITY_NAMES" to 0 rows .. importing table "PM61_SECURITY_REFS" IMP-00058: encountered ORACLE error 942 ORA-00942: Table or view does not exist importing 0 rows .. importing table "PM61_VER_BINVAL" IMP-00058: ORACLE error 942 ORA-00942: Table or view does not exist importing 0 rows .. importing table... "PM61_VER_BUNDLE" IMP-00058: ORACLE error 942 ORA-00942: Table or view does not exist 3 rows imported .. importing table "PM61_VER_NAMES" to 0 rows .. importing table "PM61_VER_REFS" IMP-00058: ORACLE error 942 ORA-00942: Table or view does not exist importing 0 rows .. importing table "SYS_LDAPINIT" to 1 line .. importing table "SYS_NAMESPACE" to 0 rows .. importing table "SYS_REPMEMBER" to 0 rows .. importing the table "SYS_REPW" into two rows successfully terminates the import, but a warning is displayed. Check the exported log and find the problem: 1. The dmp file is exported from 10.02.01. 2. The target database version is 10.2.0.1.0. 3. The client used to import dmp is 11.2.0.1.0, which is estimated to be caused by a version problem, I direct the data to the target data server and import everything. Why are there problems with some tables that can be imported normally? The result of the check is that all tables that cannot be imported normally contain the CLOB field.