2. Using Ingres Commands : unextenddb Command--Unextend a Database Location
 
Share this page                  
unextenddb Command--Unextend a Database Location
The unextenddb command unextends a database location that was previously extended by the extenddb command, and deletes the entry for the location in the configuration file. The location can then be used again by the extenddb command. If tables or files exist in the location, an error message is issued and the database cannot be unextended at that location.
Note:  After unextending a database location, you should checkpoint the database. Previous checkpoints cannot be used because they reference a location that is no longer accessible to the database.
The unextenddb command has the following format:
unextenddb -llocation [dbname...] [-Udata,work|awork] [-P] [-uuser]
-llocation
Specifies the name of the location to be unextended.
dbname…
Specifies the list of databases to be operated on by unextenddb, and if required, the vnode, as described in Standard Flags and Parameters.
-Udata,work|awork
Specifies the use of the extended location. Valid uses include database, work, and auxiliary work.
-P
Indicates the password if the session requires one.
-uuser
Specifies the effective user for the session, as described in Standard Flags and Parameters.