Installing the Schema

The steps and examples in the cue cards are based on tables that are part of the Fusion Order Demo (FOD) schema. This schema is also used as the database for the sample application that ships with Oracle JDeveloper 11g, as well as other collateral in this release. It will be convenient to have this schema installed, and you only need to do it once. If you have already installed the FOD schema, you can skip this step and go directly to the next card.

To install the schema, you will also need to have an Oracle database and access to a privileged (DBA) user which has permissions to create users. Any Oracle 10g version (or later) of the database should work for this schema. If you do not have a database available, you can easily download and install the free Oracle Database 10g Express Edition . Make sure you take note of the DBA username and password you set up during the installation, as you will need that information later.

With access to an available database, you can continue with the instructions in this cue card.

To install the schema, you will download and expand a zip file, then use Ant to perform the installation. 

If you install the sample schema, you will be able to follow the steps in the cue cards exactly as written. If you work with your own database, you can supply your own values as needed.