Oracle Designer Tutorial


Prev Next

Lesson 6
Build a database

Having refined the database design, you use the Server Generator to generate the server-side components for the system.

The Server Generator can create objects on a local or remote database from definitions recorded in the repository.

During this lesson you will:

Create the database tables

Oracle Designer can take the table definitions created by the Database Design Transformer and create the database that your applications will use to store data.

Objective

To create the database tables required for your system.

Instructions

  1. In the Design Editor, select GenerateGenerate Database From Server Model. This opens the Generate Database From Server Model dialog box.

  2. On the Target tab, choose the Database option button and enter the connection details (the same as for your current connection).

  3. On the Objects tab, move all objects into the Generate list by clicking the double-right-arrow button.

    double right arrow button

  4. Click the Start button. The messages window is opened in the Design Editor. This reports the progress of the generation process.

    When generation is complete, the Generation Complete dialog box opens.

    Generation Complete dialog box

  5. Click the Execute DDL button. This creates the database tables and other objects.

After the 'Processing Complete' message appears in the message window, you can use the Database Navigator to see the database objects that have been created.

You open the Database Navigator by selecting ToolsDatabase Navigator. Note that no triggers have been created for any of the tables. You should close the Database Navigator before continuing.

You can close the Design Editor. There is no need to save the server model diagram that you created, but you may do so if you wish.


Lesson summary

In this lesson you used the Server Generator to create the tables on the database.



Next

Prev

Next

oracle.gif (1205 bytes) 
Copyright © 2000 Oracle Corporation.  
All Rights Reserved.