Rename, unlock, or copy a database-related object.
alter object sample.basic.genref of type rules_file rename to 'level';
Renames a rules file in the Sample Basic directory, namedgenref.rul
, tolevel.rul
.
alter object sample.basic.Calcdat of type text rename to 'c_data';
Renames a text file in the Sample Basic directory, namedcalcdat.txt
, toc_data.txt
.
alter object samppart.company.company of type partition_file unlock;
Unlocks the partition definition file for the Samppart Company database.
Attempting to rename or copy an object of type "partition_file" will result in an error.
Use alter object to edit objects in the following ways:
Key Phrase | Explanation |
---|---|
rename to | Rename the object. Not applicable for partition files, worksheets, or outlines. |
unlock | Unlock an object that is locked by another user or process.
Not applicable for alias tables and worksheets.
Unlocking an object of type lro is applicable for stored
linked-reporting objects only; that is, files with the .LRO extension.
Note: To unlock all objects for a database, use |
copy to | Make a copy of a server object, giving a new name for the copy. Not applicable for partition files, worksheets, or outlines. If an object of the new name already exists, it is replaced. |
force copy to | Make a copy of a server object, giving a new name for the copy. Not applicable for partition files, worksheets, or outlines. If an object of the new name already exists, it is replaced. If a supervisor issues the statement and uses the force keyword, then any locked objects are unlocked so that the copy can proceed, and then the objects are then re-locked so that they are in the same state as before the copy. |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |