If you have dropped the sample schemas from Oracle9i or Oracle 10g, or if you did not install them in the first place, you should install them following the instructions in Oracle9i Sample Schemas or Oracle Database Sample Schemas 10g Release 1 (10.1).

If you are using the sample schemas for the first time, you may find that you must unlock the HR and OE sample schema users, and then grant CONNECT and RESOURCE roles to them. You can do this by using Oracle Enterprise Manager, which is part of Oracle9i or Oracle 10g.

Alternatively, you can issue the following SQL*Plus commands:

ALTER USER hr IDENTIFIED BY hr ACCOUNT UNLOCK;
GRANT CONNECT, RESOURCE to hr;

ALTER USER oe IDENTIFIED BY OE ACCOUNT UNLOCK;
GRANT CONNECT, RESOURCE to OE;

To invoke SQL*Plus from JDeveloper, select a database connection in the Connection Navigator, then choose Tools > SQL*Plus from the menu. The first time you do this, a dialog appears asking you to specify the location of SQL*Plus.

Download the 8i sample schema scripts to your machine and extract them to a directory on your machine.

Create a new workspace:
Right-click the Application node in the Application Navigator and select New Application Workspace from the context menu.

Name the application workspace Samples, then click OK.

With Project selected in the Application Navigator, click Open, or choose File | Open from the menu.

In the Open dialog, browse to change the Location to the directory where you extracted the sample schema scripts. Select the mksample8.sql script. Make sure that Add to Project is checked and then click Open to add the script to your project. The script is added to the project and opens automatically in the code editor.

Log files are saved by default to C:\TEMP\. If you are using UNIX, or want to save the log files to another location, you must change the occurrence of C:\TEMP\ in mksample8.sql to a new location. In the code editor, change C:\TEMP\ to a different location if needed.

In the Application Navigator, right-click mksample8.sql and select Run in SQL*Plus, then select the database connection to use. This opens a SQL*Plus window where the script runs.

When prompted, enter the system password, the database name (preceded by @), the sys password, and passwords hr8 and oe8 for the hr8 and oe8 users.

After the script has completely run, type Exit to close the SQL*Plus window.

The scripts create the users oe8 and hr8 in the database using the passwords you have defined for them. The tables and other database objects in the schemas are also created and populated with sample data.

You can examine the installation process in the log files mksample8hr8_main.log and mksample8oe8_main.log which are either in C:\TEMP\ or another location that you have defined. Note that the log will show an error if the user did not previously exist because the first action of the script is to drop the user. You can ignore this error.

With Project selected in the Application Navigator, click Open, or choose File | Open from the menu.

In the Open dialog, browse to change the Location to the folder into which you extracted the sample schema scripts. Control-click to multi-select the hr8_drop.sql and oe8_drop.sql scripts. Make sure that Add to Project is checked and then click Open to add the scripts to your project. The scripts are added to the project and opened automatically in the code editor.

In the Application Navigator, right-click the hr8_drop.sql file select Run in SQL*Plus, then select the database connection to use. This opens a SQL*Plus window.

When prompted, enter the password for the hr8 user concatenated with the database name, separated by @; for example, hr8@mydb.

When the script finishes running, type exit to close the SQL*Plus window.

Choose View | Connection Navigator.

Right-click the Database node and choose New Database Connection from the context menu.

In the Create Database Connection wizard, review the information on the Welcome page and click Next.

In the Connection Name field type a name for the connection.

The example uses the name tutorial_jdbc_connection, but you can use any name. Click Next.

On the Authentication page:

In the Username and Password fields, type the user name and password.

If you are using the sample schema scripts on an Oracle9i or 10g database, use the HR user for the Human Resources schema or the OE user for the Order Entry schema.

If you are using the Oracle8i sample schemas installed following the instructions in Creating and Populating the Sample Schema Tables, use the HR8 user for the Human Resources schema or the OE8 user for the Order Entry schema.

Select Deploy password.

Click Next.

On the Connection page:

In the Host name field, type the name (or IP address) of the computer where the database is located.

In the JDBC Port and SID fields, enter the information for the connection to the database. If you do not know these values, check with your database administrator.

Click Next.

Click Test Connection.

If the database is available and the connection details are correct, you will see Success! in the Status window.

If an error occurs, verify the settings with your database administrator, click Back to make any changes necessary, and then retest the connection.

Click Finish. The connection now appears below the Database connection node in the Connection Navigator.

Create two connections of different names to use in JDeveloper samples and other OBEs:

A connection named hr_conn to the HR or HR8 schema

A connection named oe_conn to the OE or OE8 schema

You can reuse these connections any time that you need JDBC access to the HR/HR8 or OE/OE8 schemas in this database.

Choose View | Connection Navigator.

Expand Database, then the node for the connection you have just made, then the node for the hr or OE schema. You can browse the database elements for this schema and use them in the JDeveloper OBEs.