background image
<< Unacceptable NLS Parameters | Planning for Deployment >>
<< Unacceptable NLS Parameters | Planning for Deployment >>

Deploying a Database Application

Deploying a Database Application 7-1
7
Deploying a Database Application
This chapter describes how to package and install the database objects that support an
application. For examples, it uses objects that you created if you followed the
instructions earlier in this guide. It takes you through the process of gathering object
definitions and data to deploy on another system. In a real-world environment, the
exercise would probably not be simple as laid out in this guide, but the steps and
considerations discussed would be the same.
Oracle recommends that you use a consistent prefix for all object names. This makes
the objects easy to identify. It groups them together in the SQL Developer Connections
navigator display and when you are reviewing SQL Developer reports and
performance queries against the Oracle Database data dictionary.
This chapter contains the following sections:
Overview of Deployment
on page 7-1
Deployment Environments
on page 7-1
Planning for Deployment
on page 7-2
Exporting the Database Objects
on page 7-3
Exporting the Data
on page 7-10
Performing the Installation
on page 7-11
Validating the Installation
on page 7-12
Archiving the Installation Scripts
on page 7-13
Overview of Deployment
Deployment of an application is typically not complete unless the database objects that
support the application are also deployed. You can deploy these objects by creating
scripts that create both the database objects and any necessary data, such as seed data
for lookup tables. The database objects include tables, views, functions, packages, and
others that you created to implement the application logic.
Deployment Environments
When you deploy an application for Oracle Database, you should create the following
system environments: