Command Reference Guide > Command Reference Guide > Using Ingres Commands > relocatedb Command--Move a Location to a New Location > relocatedb Example: Relocate the Work Area
Was this helpful?
relocatedb Example: Relocate the Work Area
The following command relocates the work location for the empdata database to newwork:
relocatedb empdata -new_work_location=newwork
The command above does the following:
• Performs an update to the iidbdb: update iidatabase.sortdev=’newwork’ where name=’empdata’. (This can be verified by connecting to the iidbdb database and doing a select from iidatabase where name=’empdata’.)
• Updates the default work location in the configuration file. (This can be verified by examining the output of the infodb empdata command.)
• No files are copied for work locations.
Last modified date: 11/28/2023