Customizing target directory structure for database export
This topic describes how to customize the target directory layout for database export.
In the V2P export process, it may be necessary to customize the target directory structure which the files will be exported to. The following is the default directory structure:
Data files:
<target directory>/dataArchive files:
<target directory>/archiveTemp files:
<target directory>/tempExternal files:
<target directory>/externalScript files:
<target directory>/script
Note: The example on this page uses / for file separators which is relevant for Unix and Linux environments. If the target environment is Windows, the file separator will be \.
The following procedure describes how to customize the directory layout.
Procedure
During the virtual to physical export process, click Advanced in the V2P Wizard to see the target directory options.
You can customize any of the following:
Data directory
Archive directory
Temp directory
External directory
Script directory
Each directory will then be concatenated to the Target directory separated by the appropriate separator.
Any one of Target directory, Data directory, Archive directory, Temp directory, External directory, Script directory can be blank. However, the combination of the fields must form an absolute path.
Data files:
<target directory>/<data directory>Archive files:
<target directory>/<archive directory>Temp files:
<target directory>/<archive directory>External files:
<target directory>/<external directory>Script files:
<target directory>/<script directory>
Examples
Target directory is not empty
This means all target directories have a common root.
Input | Final directory layout |
|---|---|
|
|
Target directory is empty
All target directories may not have a common root. Note that external files and temp files share the same common root.
Input | Final Directory Layout |
|---|---|
|
|
Target directory is empty and data directory /
Combined with Customizing VDB file mappings, exporting data files to separate file systems is possible. In this example, a.dbf and b.dbf can be exported to /filesystem1 and /filesystem2 respectively. For Oracle VDBs, it is necessary to specify the parameter useAbsolutePathForDataFiles in order to export data files to separate file systems. See CLI Cookbook: V2P (virtual to physical) of a single instance Oracle database with datafiles on separate file systems for details.
Input | Final directory layout |
|---|---|
|
|
Target directory is empty and one of the subdirectories is empty would result in an error.
Input | Final Directories |
|---|---|
|
|
For parallel execution of V2P operations from the same target, make sure that the scripts directory name is unique.