Oracle Repository

This topic describes how to create an Oracle repository.


  • This feature is available in the Corporate, Business and Software Engineering, System Engineering and Ultimate editions.
  • Before starting, you must have the appropriate version of Oracle (9i, 10g or 11g) and MDAC 2.6 or higher installed, and you must have the appropriate permission to create a new database. The process of setting up Oracle is beyond the scope of this User Guide; please consult your Oracle documentation for further guidance.

Sparx Systems provides SQL scripts to create the required Enterprise Architect repository tables, on the Sparx Systems website. You can execute the scripts in any way you prefer.

Create the Repository

To create an Oracle repository, follow the steps below:

  1. Create a new database on the Oracle server.
  2. Connect to the newly created database with a program such as Oracle SQL*Plus or SQL Plus Worksheet.
  3. Execute the script Oracle_EASchema.sql, which creates the tables and indexes for an Enterprise Architect project.


Oracle repositories are created without any data, so you must perform a project data transfer in Enterprise Architect to copy a suitable starter project. If you are starting from scratch, EABase.EAP is a good starting point. If you are using an existing .EAP model, you can upsize it.