Imp imp-00003:oracle error 959 encountered ORA-00959 problem resolution

EXP Export Environment:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

Sql> SELECT * from nls_database_parameters where parameter= ' nls_characterset ';

PARAMETER VALUE
------------------ ----------
Nls_characterset ZHS16GBK

IMP Import Environment:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

Sql> SELECT * from nls_database_parameters where parameter= ' nls_characterset ';

PARAMETER VALUE
------------------ ----------
Nls_characterset ZHS16GBK

Error code:

Imp imp-00003:oracle error 959 encountered

Problem Analysis:

The table in the EXP export file contains the Clob field

Problem solving:

1. Before importing, create a new table with the Clob field in IMP import environment and specify table space

2, Import command add ignore=y option or data_only=y (support after 11g)

Imp sport/sport buffer=64000 file=/home/oracle/fliename.dmp full=y ignore=y;

End

Imp imp-00003:oracle error 959 encountered ORA-00959 problem resolution