Generate SQL from Offline Database Objects Wizard - Generate Options

Use to specify how to update the database. You can choose to:

• Create or replace the tables and views in the database. If you have chosen to generate a SQL file, it will contain CREATE and DROP statements,
• Update existing database schema objects. JDeveloper first reconciles the offline database definitions against the objects in the database schema to identify the changes necessary. If you have chosen to generate a SQL file, it will contain ALTER statements.
  
  Note: If you are reconciling against a database schema, there is the possibility that you will generate SQL scripts that will drop foreign keys. For more information, refer to Offline Tables and Foreign Keys.

In either case, you can choose to:

• Generate a SQL file that you can examine and run against the database later.
• Make the changes directly to the database.
• Make the changes to the database and also generate a SQL file.

CREATE (or replace) the chosen objects

Select this option to generate SQL files containing CREATE and DROP statements.

Update (reconcile) the chosen objects

Select this option to generate SQL files containing ALTER statements.

Generate SQL scripts for the operation

Select this option to generate SQL files.

Perform the chosen operation directly with the database

Select this option to make the changes directly to the database.

Related topics

Generating From Offline Table Definitions
Working with Offline Database Definitions

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