Reconciling the Database

A powerful function of JDeveloper is the ability to compare offline database object definitions with live database objects. You can visually compare each change and choose to either generate that change to the database in the form of an ALTER script, or live to the database.

You will use the Edit Table dialog to make changes to your previously created offline objects and compare those changes to the live version of the objects in the database. To open the dialog, you will double-click the table in the Application Navigator.

You will then use the Generate SQL from Database Objects wizard to generate a SQL script to update the live database definitions.

Copyright © 1997, 2009, Oracle. All rights reserved.