Moving all objects from one tablespace to another

Moving all objects in one tablespace to another tablespace is something very easy to be done. As shown in the previous example, all you need to do is to use the parameter REMAP_TABLESPACE on your import command as shown in the following example:

$ impdp fcomunoz/alvarez@pdborcl directory=datapump dumpfile=mv_tablespace_06192013.dmp remap_tablespace=test:test2

Note

Please ensure that the destination tablespace exists before executing this example.