Oracle 10g client exports full data for 11g users __oracle

In order to do the virtual machine, you need to the server 11g of the user's complete data out. The oracle10g on the virtual machine, directly exported, cannot be imported to the virtual machine.

So, try to export the data using a 10g client,

With command: Exp exoa/***** @exoa1 file=20100526.dmp grants=y full=y

After execution, the system prompts:

EXP-00008: Oracle Error 1406 encountered

ORA-01406: The extracted column value was truncated

EXP-00000: Export termination failed

Later, another method that was seen on the web was used: Export with the EXPDP command on the 11g server side, then import with the IMPDP command in 10g:

Export command: EXPDP exoa/**** @exoa1 schemas=sybjdirectory=data_pump_dir dumpfile=aa.dmp logfile=aa.log version=10.2.0.1.0

After successful export, the DMP file is sent to a colleague, and it is not known whether he can import successfully.

It is still not known why you cannot export under 10g clients.