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

Creating your database in a different file structure

Duplicating your database using a different structure is very easy to be done using Data Pump; all you need to do is use the parameter REMAP_DATAFILE on your import command as shown in the following example:

$ impdp fcomunoz/alvarez@pdborcl directory=datapump dumpfile=diff_structure_06192013.dmp remap_datafile='/u01/app/oracle/oradata/pdborcl/datafile_01.dbf':' /u01/app/oracle/oradata/pdborcl2/datafile_01.dbf'

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