Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
The RENAME command changes the name of an analytic workspace or an object in an analytical workspace.
Syntax
RENAME oldname newname [AW workspace]
Arguments
The name of an existing analytic workspace or an existing object in an analytic workspace. You can specify a qualified object name to indicate the attached workspace in which the object resides. As an alternative, you can use the AW keyword to specify the workspace. Do not use both.
When you do not use a qualified object name or the AW keyword to specify an analytic workspace, the object is renamed in the current workspace.
For an unnamed composite, use the same syntax that was used to create it. See "Naming an Unnamed Composite".
The new name.
The new name of an analytic workspace cannot duplicate any other name of an analytic workspace in the schema in which the workspace is defined. Choose a name according to the rules for naming analytic workspaces (see the AW command).
The new name of an analytic workspace object cannot duplicate any other name in the workspace in which the object exists. Choose a name according to the rules for naming analytic workspace objects (see the main entry for the DEFINE command. To change a named composite to an unnamed composite, use the SPARSE keyword as the newname argument. See "Unnaming a Named Composite".
The name of an attached workspace in which you wish to rename the object. When you do not use a qualified object name or the AW keyword to specify an analytic workspace, the object is renamed in the current workspace.
Notes
Updating Associated Objects
When you change the name of a variable, objects that use that variable, such as formulas, are not automatically updated.
When you change the name of a dimension, the definitions of any objects that are dimensioned by that dimension are automatically updated. Additionally, any valuesets for the renamed dimension are automatically updated for the new name.
RENAME and PERMIT
You may not rename an object when a PERMIT statement denies you the right to change its permission. Renaming an object does not affect permission associated with it.
Naming an Unnamed Composite
You can name an unnamed composite with a RENAME statement. The following example assigns the name m.prod
to an unnamed composite that is dimensioned by market
and product
.
RENAME SPARSE <market product> m.prod
Unnaming a Named Composite
You can change a named composite to an unnamed composite when the composite has no properties or permission restrictions and when there is at least one object dimensioned by it. In addition, there cannot be an unnamed composite with the same dimensions in the same order as the named composite, and the named composite cannot be used in the dimension list of any unnamed composite. To change a named composite to an unnamed composite, use the SPARSE keyword as the newname argument. The following example changes the named composite m.prod
to an unnamed composite.
RENAME m.prod SPARSE
Restrictions on Renaming Composites
You cannot rename a composite when it is a base dimension of an unnamed composite, or when one of its base dimensions is an unnamed composite.
Examples