The rules for a simple name are:
1 to 30 bytes.
Not an Oracle reserved word.
Unique within the namespace.
Not case-sensitive; any lower-case letters are converted to uppercase.
No quotation marks.
Begins with an alphabetic character from the database character set.
The following namespaces control the uniqueness of object names:
Schema. The names of cubes and dimensions must be unique within a schema. They cannot conflict with the names of tables, views, indexes, relational dimensions, or any other first class objects.
Cube. The names of measures must be unique within a cube.
Dimension. The names of hierarchies, levels, and attributes must be unique within a dimension and among themselves. For example, a dimension cannot have a hierarchy named Total and a level named Total.
Copyright © 2003, 2007, Oracle. All rights reserved.