Create an Oracle 9i or 10g Server Repository

Return to Introduction  Previous page  Next page

Note: This feature is available in the Corporate edition only.

Before creating an Oracle 9i or 10g data repository, you must have Oracle 9i or 10g and MDAC 2.6 or 2.7 installed, and access access permission to create a new database. Please note that setting up Oracle and the issues involved are beyond the scope of this manual. Consult your program documentation for guidance.

Sparx Systems provide SQL scripts to create the required tables; how you create the database and execute that script are up to you.

·Registered users can obtain the scripts from the Registered Corporate edition Resources page of the Sparx Systems website at http://www.sparxsystems.com/registered/reg_ea_oracle_instructions.html.
·Trial users can obtain the scripts from the Corporate edition Resources page of the Sparx Systems website at http://www.sparxsystems.com/resources/corporate/

Creating the Data Repository

Oracle 9i and 10g  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 want to use an existing .EAP model, you can upsize it; follow the steps below:

1.Create a new database on the Oracle 9i or 10g 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_BaseModel.sql, which creates the base model tables and indexes for an Enterprise Architect Project.

Tip: Use the Project Data Transfer function to upload a basic model into the repository.