Oracle 11g IMP-00058

Import the four. dmp files to the Oracle 10 Gb database. I installed the Oracle 11 GB database on my local machine. If I didn't want to, I would just export the files.

Use the import table function in PLSQL Developer to export data.

1. Create a tablespace, create a user, and assign permissions;

Tablespace:

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:

Create user czportal identified by a12345
Default tablespace GPORTAL
Temporary tablespace temp;

Permission:

Grant connect, resource, dba to czportal;

2, okay! Data Import started. Use PLSQL Developer or IMP commands

Imp czportal/a12345@192.168.0.23: 1521/orcl file = c: \ dmp \ czportal130311.dmp log = c: \ dmp \ czportal130312.log full = y ignore = y

An error is returned.

IMP-00058: encountered ORACLE error 942
ORA-00942: The table or view does not exist importing 0 rows

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options

EXPORT File Created by EXPORT: V10.02.01 in the normal path
The ZHS16GBK Character Set and AL16UTF16 NCHAR character set have been imported.
The import server uses the AL32UTF8 character set (possible Character Set conversion)
. Importing the GCR object to GCR
... Importing the table "CMS_FILTER" to 0 rows
... Importing the table "DS_BACKUP" to 0 rows
.. Importing table "DS_BKCFG" 0 rows
... Importing the table "DS_INDEX" to 0 rows
.. Importing table "DS_LEXICON" 0 rows
... Importing the table "DS_LOG" into three rows
.. Importing the table "FILTER" into 0 rows
... Importing the table "PM61_DEFAULT_BINVAL"
IMP-00058: encountered ORACLE error 942
ORA-00942: The table or view does not exist importing 0 rows
... Importing table "PM61_DEFAULT_BUNDLE"
IMP-00058: encountered ORACLE error 942
ORA-00942: The table or view does not exist and 4144 rows are imported
.. Importing the table "PM61_DEFAULT_NAMES" to 0 rows
... Importing table "PM61_DEFAULT_REFS"
IMP-00058: encountered ORACLE error 942
ORA-00942: The table or view does not exist importing 0 rows
... Importing table "PM61_SECURITY_BINVAL"
IMP-00058: encountered ORACLE error 942
ORA-00942: The table or view does not exist importing 0 rows
... Importing table "PM61_SECURITY_BUNDLE"
IMP-00058: encountered ORACLE error 942
ORA-00942: The 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: The table or view does not exist importing 0 rows
... Importing table "PM61_VER_BINVAL"
IMP-00058: encountered ORACLE error 942
ORA-00942: The table or view does not exist importing 0 rows
... Importing table "PM61_VER_BUNDLE"
IMP-00058: encountered ORACLE error 942
ORA-00942: The table or view does not exist and 3 rows are imported
.. Importing table "PM61_VER_NAMES" 0 rows
... Importing table "PM61_VER_REFS"
IMP-00058: encountered ORACLE error 942
ORA-00942: The table or view does not exist importing 0 rows
... Importing the table "SYS_LDAPINIT" to 1 row
.. Importing the table "SYS_NAMESPACE" to 0 rows
.. Importing table "SYS_REPMEMBER" 0 rows
.. Importing table "SYS_REPW" 2 rows
Import is terminated successfully, 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

It is estimated that it is caused by a version problem. I directly import data to the target data server, and everything is normal.

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.