Explanation: Look in the target database server console log for a message like this:

Cannot open dbspace 'xxx' from file 'incorrect-filespec'.

If that's the problem, fix the filespec in the target database

ALTER DBSPACE xxx RENAME 'correct-filespec';