True, but then I'd say the remap functionality in impdp doesn't do a complete job, does it? same is true if you have plsql scripts that have schema names prefixed, it won't translate them properly. We still have issues with importing job or program arguments with remap_schema. Sorry, didn't want to hijack the thread, but basically impdp needs to improve :) Raj On Mon, Apr 23, 2012 at 1:45 PM, <gints.plivna@xxxxxxxxx> wrote: > [snip] Schema names in both environments were different, according to docs > dp import doesn't remap schema for enclosed nested table types. The > solution was to make temp tables for enclosed nested tables. So since then > I have another very strong argument NOT to use nested tables in DB. > -- //www.freelists.org/webpage/oracle-l