Control Repository - Implementation Notes

Implementing in Oracle XE:

• Upload to CTL:
• run_no_s.sql
• repositories_a.sql
• repositories_t.sql
• repositories_i.sql
• repositories_c.sql
• repositories_d.sql
• mapping_libraries_a.sql
• mapping_libraries_t.sql
• mapping_libraries_i.sql
• mapping_libraries_c.sql
• mapping_histories_a.sql
• mapping_histories_t.sql
• mapping_histories_i.sql
• mapping_histories_c.sql
• ctl_gen_a.sql
• ctl_gen_h.sql
• ctl_gen_b.sql

• Run the following scripts in order:
• CTL script: run_no_s.sql
• CTL script:repositories_a.sql
• CTL script: repositories_d.sql
• CTL script: mapping_libraries_a.sql
• CTL script: mapping_histories_a.sql
• CTL script: ctl_gen_a.sql
• CTL command: EXEC lib_util.create_grants;
• STA command: EXEC lib_util.create_synonyms;
• VAL command: EXEC lib_util.create_synonyms;
• ODS command: EXEC lib_util.create_synonyms;

• Run the test script; CTL: ctl_gen_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.
• Run the test script; STA: ctl_gen_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.
• Run the test script; VAL: ctl_gen_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.
• Run the test script; ODS: ctl_gen_test.sql. NOTE: Best run from the SQL Command Line.
  
• Each test outputs a result and, at the end, a pass/fail summary.