Naming Objects
Make an object name as descriptive as possible to help other users understand its purpose.
Your company may develop naming conventions; see Customizable Naming Validation Package.
- Special Characters and Reserved Words
To avoid problems, do not use special characters such as ( & @ * $ | % ~ -) in object names, except for underscore (_). Also do not use Oracle SQL or PL/SQL reserved words in object names, especially the Oracle name. - Duplicate Names: System Appends _1
Oracle Life Sciences Data Hub enforces unique naming for each object type in the same container, whether the container is an organizational object—Domain, Application Area or Work Area—or a Report Set or Workflow. (Report Sets contain Programs. Workflows may contain Programs, Load Sets, Report Sets, and/or Data Marts.) - Automatic Name Truncation
Names can contain up to 200 characters. However, the system populates the values for Oracle Name and SAS Name with the value you enter for Name stored in uppercase, truncating the Oracle Name to 30 characters and the SAS Name to 32 characters. - Keep Container and Object Names Short for Integrated Development Environments
Although names can contain up to 200 characters, the maximum length of a file path is 256 characters in Windows. - Naming Rules for Specific Object Types
This section contains the following topics. - Customizable Naming Validation Package
Oracle Life Sciences Data Hub object creation and modification code includes a call to a predefined validation package from every object name field.
Parent topic: Common Development Tasks