![]() Previous |
![]() Next |
The AW ALIASLIST command assigns or deletes one or more workspace alias for the specified attached workspace or, when no workspace is specified, for the current workspace. ALIAS indicates that the alias or aliases should be assigned, and UNALIAS indicates that the alias or aliases should be deleted. All aliases for a given workspace are automatically deleted when you detach an analytic workspace.
Syntax
AW ALIASLIST [workspace] {ALIAS|UNALIAS} alias1, alias2, ...
Parameters
The name of the analytic workspace. You can specify either an analytic workspace name or an analytic workspace alias, depending on the keywords you are using.
Assigns one or more workspace alias for the specified attached workspace or, when no workspace is specified, for the current workspace. ALIAS indicates that the alias or aliases should be assigned, and UNALIAS indicates that the alias or aliases should be deleted.
All aliases for a given workspace are automatically deleted when you detach an analytic workspace. Therefore, each time you attach an unattached workspace, you must reassign its aliases.
Deletes one or more workspace alias for the specified attached workspace or, when no workspace is specified, for the current workspace.
The alias name for the analytic workspace. Alias names:
Can be from 1 - 26 characters in length. All characters must come from the database character set and must be letters, numerals, or underscores.
Cannot begin with a numeral and cannot be reserved words in the DML. (Use RESERVED to identify reserved words.)
Examples
Assigning an Alias
The following statement assigns sdemo
as an alias for the demo
workspace, which was created by a user named scott
. The full name of the workspace is specified because the current user is not scott
.
AW ALIASLIST scott.demo ALIAS sdemo
In the following statement, the user named scott
assigns mydemo
as an alias for the same workspace.
AW ALIASLIST demo ALIAS mydemo