Oracle Designer Tutorial: Creating an Oracle Database

Oracle Designer (OD) must be used to design the databases that will be used for D0 in Run II. This document is a tutorial showing how to use Oracle Designer to generate the code necessary to produce a database on the development platform. It shows how to use Oracle Designer to • create tables, relations, and views, • assign and grant Roles, • specify triggers and constraints and • generate accurate storage requirements. Every design should contain many, if not all, of these elements. With the basic tools described in this document, a database designer will be familiar enough with OD to go forth to develop larger applications with more complex features. The author emphasizes that the advice and assistance of the Fermilab Support DB Project group are invaluable in this process. Keeping them in the loop will enhance the success of your database project