Database Administrator Guide > Database Administrator Guide > Loading and Unloading Databases > Copying and Relocating a Database > Example: Copy a Database to a New Database and Use New Locations
Was this helpful?
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 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.
Last modified date: 08/14/2024