Technical data

Database Maintenance Rules
Database Overview 1-3
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 of these components is outlined in the installation section of this document.
What Changes Are Permitted
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.
• 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 (that is, 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 in this document.
What Changes Are Not Permitted
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 in anyway (altered, removed or added).
• 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.