Oracle imports DMP files that contain CLOB fields error resolution ____oracle

Assuming that the data user USER1 uses the default tablespace TS1, the user USER2 uses the default table space TS2, and now imports USER1 data into USER2, which requires tablespace TS2.

It is not possible to specify tablespace through imp command parameter tablespaces.

At this time there is a simple method, suitable for the case of relatively few data: direct use of UltraEdit DMP file, the default is 16 into the system.

Through the formula bar-toggle hexadecimal mode, displaying in strings

Through the ctrl+f will be inside the: tablespace "TS1" all replaced Tablespace "TS2", and then import

No need to add any tablespaces=ts2 and other parameters can, of course, add also nothing called.

C:\>imp user2/user2 log=c:\plsimp.log file=d:\database\user1.dmp fromuser=user1 touser=USER2 Tablespaces=ts2

Note: You may still be prompted incorrectly during the import process to replace the user with the target user in a similar way.