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.
Get Oracle Database 12c Backup and Recovery Survival Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
