This discussion is archived
5 Replies Latest reply: Jan 20, 2013 3:28 AM by FrankT RSS

IMPDP REMAP_TABLESPACE(multiple tablespaces)

701097 Newbie
Currently Being Moderated
Hello All,
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?

Thank you in advance.

-Mal.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points