Database Maintenance Rules
The database supplied with the product consists of the following elements:
• A set of users to administrate, execute and read the database schema provided.
• A set of database roles to implement security for each of the users provided.
• A tablespace and a schema containing the base database objects used by the product.
The installation instructions are outlined in the installation section of this document.
Permitted Database Changes
During and after installation of the product the following changes may be performed by the database administrator personnel on site:
• Users supplied by product may be changed according to the site standards.
• Database objects may be added to the schema according to database naming standards outlined later in this document.
• Database views and indexes may be created against base database objects. Please make sure to prefix new items with “CM” (for customer modification).
• Database storage attributes for base indexes and base tables may be changed according to site standards and hardware used.
• Tablespace names, attributes and locations may be changed according to site standards.
• Database topology (base table/index to tablespace, tablespace to data file, data file to location) may be altered according to tuning and/or site standards.
• Database triggers may be created against base database objects unless they attempt to contravene base data integrity rules.
• Database initialization and parameter settings may be altered according to site standards unless otherwise advised by Oracle Support or outlined.
Non-Permitted Database Changes
In order to maintain operability and upgradeability of the product, during and after the installation of the product, the following changes may not be performed by the database administration personnel on site.
Base objects must not be removed or altered in the following ways:
• Columns in base tables must not be altered, removed or added in anyway.
• Columns in Indexes must not be altered or removed.
• Tables must not be renamed or removed.
• Base views must not be renamed or removed.
• Base Triggers and Sequences must not be renamed or removed.
• Base indexes must not be altered or removed.