Oracle Output Files

The Oracle7 DBMS specifications generated by the OPM Schema Translator are contained in six files consisting of:

1. specifications for tables (relations), user defined types, and views; the name of this file consists of the database name or the name of the file containing the input OPM schema, followed by _relations.[ ORA7];

2. specifications of rules for maintaining valid values for user defined types; the name of this file consists of the database name or the name of the file containing the input OPM schema, followed by _datarules.[ ORA7];

3. specifications regarding data dictionary definitions for primary keys; the name of this file consists of the database name or the name of the file containing the input OPM schema, followed by _primarykeys.[ ORA7];

4. specifications regarding data dictionary definitions for foreign keys; the name of this file consists of the database name or the name of the file containing the input OPM schema, followed by _foreignkeys.[ ORA7];

5. procedural specifications for maintaining referential integrity constraints and rules; the name of this file consists of the database name or the name of the file containing the input OPM schema, followed by _ritriggers.[ ORA7];

6. procedures for verifying (off-line) the referential integrity of an existing database; the name of this file consists of the database name or the name of the file containing the input OPM schema, followed by _check.[ ORA7].

• Oracle 7 Database Definition
  • Table and View Definitions
  • Rules
  • Primary Keys
  • Foreign Keys
  • Trigger Procedures
  • Referential Integrity Verification Procedures