Categories
Software & Development

oracle impdb remap_schema with additional space

Today, I tried to run impdb with remap_schema:old_owner:new_owner syntax and I ended up with empty database and plenty of errors.

The problem was that impdp tried to import from “old_owner” to “new_owner “. Do you see the difference? One additional space, because impdp somehow misunderstood the parameter separator as a part of new_owner.

Problem occurs in case of oracle 11.20 @ solaris. Solution is to provide remap_schema as a last parameter.