6. Loading and Unloading Databases : Copying and Relocating a Database : Example: Copy a Database to a New Database and Use New Locations
 
Share this page                  
Example: Copy a Database to a New Database and Use New Locations
The following example copies the empdata database to a new database, empdev, and specifies the new locations--empdat1 and empdat2--for the existing ii_database and edata locations.
relocatedb empdata -new_database=empdev
   -location=ii_database, edata
   -new_location=empdat1, empdat2
In VDBA:
1. Follow Steps 1–3 in the Example: Copy a Database to a New Database.
2. Enable the Reassign Location check box.
The locations that are currently being used by the empdata database (ii_database and edata) are displayed in the Initial Location column.
3. In the New Location column, double-click on the location to be changed and select the new location from the drop-down list box.
For example, double-click on the ii_database location in the New Location column and select empdat1. Change the edata location to empdat2.
4. Click OK.