About Working with Offline Database Definitions

JDeveloper provides the tools you need to create and edit database objects such as tables and constraints outside the context of a database. You can create new tables and views and generate the information to a database, or you can import database objects from a database schema, make the changes you want and then generate the changes back to the same database schema, to a new database schema, or to a file that you can run against a database at a later date. Alternatively, you can use JDeveloper's modeling tools to visualize your offline database objects on a diagram.

For information about creating new database objects, see Creating New Offline Database Definitions and Modeling Offline Database Definitions.

For information about working with offline database definitions imported from a database schema, see Creating Offline Database Definitions Based on Existing Objects and Modeling Offline Database Definitions.

For information about uploading information from your offline tables, views and contraints to a live database or to a script see Generating from Offline Database Definitions.

Note: Import from a database and generation to a database are not certified against non-Oracle databases.