The MOVE command moves an object name to a new position in the NAME dimension of an analytic workspace. The reorganizing effect of the MOVE command on the workspace is cosmetic. That is, no physical changes take place in workspace storage. Users often reorganize workspace objects so the output from DESCRIBE is easier to read.
The names of one or more objects to move. You can specify the names individually, or use one of the following forms to specify a group of names:
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 argument to specify the workspace. Do not use both.
When you do not use a qualified object name or the AW argument to specify an analytic workspace, Oracle OLAP looks for the object in the current workspace.
The logical position in the NAME dimension to which Oracle OLAP moves the objects specified by the name argument. Specifying FIRST moves the objects to the beginning of the NAME dimension. Specifying LAST (the default) moves the names to the end of the NAME dimension.
The position before or after a particular object (name2) to which Oracle OLAP moves the objects specified by the name argument.
The name of an attached workspace in which you want to move the object. When you do not use a qualified object name or the AW argument to specify an analytic workspace, objects are moved in the current workspace.
You can arrange your workspace objects alphabetically with the following statements, which work on the NAME dimension.
SORT NAME A NAME MOVE CHARLIST(NAME) FIRST
Example 10-67 Moving a Relation
This example shows how to move the relation desc.product after product. The OLAP DML statement
SHOW CHARLIST(NAME)
produces the following list (annotation has been added).
product <--- Position of product district division line region marketlevel market month year quarter desc.product <--- Old position of desc.product region.district division.product ...
The following statements
MOVE desc.product AFTER product SHOW CHARLIST(NAME)
change the workspace order and produce the following list (annotation has been added).
product <--- Position of product desc.product <--- New position of desc.product district division line region marketlevel market month year quarter region.district division.product ...