Working with Offline Database Objects

This section describes how to work with tables, views and constraints outside the context of a database schema. You can create new offline database objects, or capture them from online database schemas. Once you have finished working with them, you can generate new and updated database definitions to online database schemas.

Title
Description
About Working with Offline Database Definitions Introduction to working with offline database tables, views and constraints.
Offline Database Definitions in Team Based Development Limitations on working with offline database definitions in source control system.
Setting Paths for Offline Database Files Ideas for good working practices.
Offline Tables and Foreign Keys Ideas for good working practices.
Offline Schemas Learn how offline schemas, which are containers to organize offline database objects in the navigator, work.
Creating New Offline Database Definitions Create offline tables, views and constraints.
Importing Offline Database Definitions Based on Existing Objects Create offline database definitions from tables and views in a database schema.
Modeling Offline Database Definitions Create database definitions by visualizing them using JDeveloper's UML modeling tools.
Editing Offline Database Definitions Edit offline table, column and constraint definitions.
Removing Offline Database Definitions Delete offline database definitions and their dependent objects.
Refreshing Offline Database Objects Refresh from the database offline database definitions and their dependent objects.

Generating from Offline Database Definitions

Upload offline database tables to a database schema.

Working with the Database

 

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