O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required