ORA-01435 user does not exist processing when IMP

When doing IMP full import, first create a good table space (because the file location is different), import with the ignore=y option, the original thought can be imported successfully. Results of the final report:

"ALTER SESSION SET current_schema=" MATERIAL ""

Imp-00003:oracle Error 1435 encountered

Ora-01435:user does not exist

Imp-00000:import terminated unsuccessfully

From the error point of view, because the MATERIAL user does not exist, look through the log, found in the previous :

Mp-00017:following statement failed with ORACLE error 959:

"CREATE USER" MATERIAL "identified by VALUES ' EBFAC36458941377 ' DEFAULT tabl"

"ESPACE" tsp_material "temporary tablespace" TEMP ""

Imp-00003:oracle Error 959 encountered

Ora-00959:tablespace ' tsp_material ' does not exist

The original is because the tablespace tsp_material does not exist, causing the user MATERIAL not to be created .

Re-create the tsp_material table space to resolve the problem.

Summary: This problem is usually accompanied by the ALTER SESSION SET current_schema statement exists. In addition,ignore is not anything wrong is ignored, or selective.

ORA-01435 user does not exist processing when IMP