2. Using Ingres Commands : relocatedb Command—Move a Location to a New Location : relocatedb Example: Relocate the Work Area
 
Share this page                  
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.