The names of objects (table or view names, column or attribute names, model names, names of output objects) must satisfy the standard Oracle naming requirements for database objects. Identifiers can be either quoted or nonquoted. Quoted identifiers are enclosed in double quotation marks (").
Identifiers must be from 1 to 30 bytes long.
Nonquoted identifiers must begin with an alphabetic character from your database character set; quoted identifiers can begin with any character.
Nonquoted identifiers cannot be Oracle Database reserved words. You cannot use the the uppercase word ROWID
, either quoted or nonquoted, as a column name.
Nonquoted identifiers can contain only alphanumeric characters from your database character set and the underscore (_), dollar sign ($), and hash mark (#). Oracle strongly discourages you from using $ and # in nonquoted identifiers. Quoted identifiers can contain any characters and punctuations marks as well as spaces. However, neither quoted nor nonquoted identifiers can contain double quotation marks or the null character (\0
).
Within a namespace, no two objects can have the same name.
Columns in the same table or view cannot have the same name. However, columns in different tables or views can have the same name.
Nonquoted identifiers are not case sensitive. Oracle interprets them as uppercase. Oracle Data Miner requires that identifiers be all uppercase. Quoted identifiers are case sensitive.
For detailed information about valid names, see the Oracle Database SQL Reference.
Warning: Model names and names of test metrics objects have additional restrictions. See Restrictions on Certain Names for information.S
Oracle Data Miner, by default, warns about the use of special characters in the names of new objects. Oracle Data Miner warns you if the name contains quotation marks, lowercase characters, or any characters, such as spaces, that require quotation marks.
Copyright © 2006, 2008, Oracle. All rights
reserved.