We have 4 table spaces for data and 4 table spaces for index on source db. We would like to use REMAP_TABLESPACE on target database. but we want to use only two table spaces on target db(one for data and one for index). Is this going to work? If yes then do i have to run two impdp command separately one for remapping four data table spaces from source to one data table space on target db and another impdp to map 4 index table spaces on source to one index table space on target db. Can you please give example here?
Even though this thread is long dead, I wanted to add the following (mainly for my own sanity; I keep finding this page when I want to know how to do it, and the last answer is not valid for at least the db version I use (11G))
To remap multiple tablespaces, repeat the remap_tablespace argument!