Alter Object

Rename, unlock, or copy a database-related object.

Syntax

Examples

alter object sample.basic.genref of type rules_file rename to 'level';

Renames a rules file in the Sample Basic directory, named genref.rul, to level.rul.

alter object sample.basic.Calcdat of type text rename to 'c_data';

Renames a text file in the Sample Basic directory, named calcdat.txt, to c_data.txt.

alter object samppart.company.company of type partition_file unlock;

Unlocks the partition definition file for the Samppart Company database.

Notes

Attempting to rename or copy an object of type "partition_file" will result in an error.

Descriptions

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 alter database DBS-NAME unlock all objects;.

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