1.2 OBTR Data model schema

This topic describes the steps to get the Oracle OBTR Data model schema.

• Identify the new Oracle Database schema for data model purpose.
• Create the OBTR database tables by running all the DDL scripts in below folder at the schema identified.
  • OBTR_14.4.0.1.0\MAIN\DATABASE\HOST\CONSOL\DDL\TABLE
  • OBTR_14.4.0.1.0\MAIN\DATABASE\BRANCH\CONSOL\DDL\TABLE
• Create Foreign Keys in schema using following scripts at the schema identified.
  • OBTR_14.4.0.1.0\MAIN\DATABASE\DATAMODEL\HOST\CONSOL\FKR
• Create column comments using below scripts at the schema identified.
  • OBTR_14.4.0.1.0\MAIN\DATABASE\DATAMODEL\HOST\CONSOL\CMT

  Note:

  The Database environment used for this data model cannot be used for other testing/production purpose.