Database Administrator Guide > Database Administrator Guide > Loading and Unloading Databases > Copying and Relocating a Database > Example: Copy a Database to a New Database and Swap Contents of Locations
Was this helpful?
Example: Copy a Database to a New Database and Swap Contents of Locations
The following example copies the empdata database to a new database, empdev, and swaps the contents of the locations ii_database and loc1 in the new database.
relocatedb empdata -new_database=empdev
   -location=ii_database, loc1
   -new_location=loc1, ii_database
In VDBA:
2. Enable the Reassign Location check box.
The locations that are being used by the empdata database (ii_database and loc1) 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 loc1. Change the loc1 location to ii_database.
4. Click OK.
Last modified date: 11/28/2023