This content has been marked as final. Show 5 replies
Is this going to work?Depends upon your definition of "work".
All other things being equal, no performance benefit results from storing tables & indexes in different tablespaces.
Please give us a syntax of impdp if it works.
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!