Certain server administration tasks require the creation and assignment of names (user names, database names, index names). This section explains the restrictions on naming, lists words that cannot be used as names and identifies characters that cannot be used in names.
Lists of the reserved words and characters can be found at Reserved Words, and Reserved Characters.
The following naming restrictions apply to all situations:
• Must start with a letter of the alphabet (A-Z)
• Cannot exceed 30 characters in total length
• Must include only alphanumeric characters or any characters not on the reserved characters list
• Cannot use a reserved word
In addition to those restrictions there are also restrictions specific to user accounts and databases.
• User names:
• Cannot be identical to the name of a user role as defined in the RDBMS
• Cannot be identical to a database name
• Cannot be the same as another existing user, regardless of the capitalization
• Database names:
• Cannot end with a space