Travel Schema

What is Travel Schema

The Travel Schema is a downloadable database schema, available for Oracle8 v8.0 or Oracle8i or Oracle9i, that contains a real-world dataset. The Travel Schema is required by many of the samples available on Oracle Technology Network, so you can import it once, and then run a series of sample applications against it.

Installing the Travel Schema

To Download and install the travel schema into the OTNTRAVEL (non-SYSTEM) tablespace:

1. Install Oracle8i or Oracle9i database. It may be easiest to select the Typical Installation, since that will automatically install a starter database into which you may import the Travel Schema.
2. Execute the below mentioned steps in SQL*PLUS. Invoke SQL*PLUS.
   Step a. SQL> Connect system/manager
   Step b. SQL> CREATE TABLESPACE OTNTRAVEL
            DATAFILE 'TRAVELDATA' SIZE 50M ONLINE
            /
   Step c. SQL> CREATE USER TRAVEL IDENTIFIED BY TRAVEL
            DEFAULT TABLESPACE OTNTRAVEL
            QUOTA 100M ON OTNTRAVEL
            /
   Step d. SQL> GRANT CREATE SESSION, IMP_FULL_DATABASE TO TRAVEL
            /
   Step e. SQL> GRANT JAVASYSPRIV, JAVAUSERPRIV TO TRAVEL
            /
   Step f. SQL> GRANT ALL PRIVILEGES TO TRAVEL
            /
   Note : If you are using Oracle 9i, perform steps g & h *only* if the UNDO_MANAGEMENT of your database is set to MANUAL. This setting can be altered using the ALTER SYSTEM command. For details, refer to the 9i SQL Reference manual that is supplied with the database.
   
   Step g. SQL> CREATE PUBLIC ROLLBACK SEGMENT OTNTRAVEL_RB TABLESPACE OTNTRAVEL
            /
   Step h. SQL> ALTER ROLLBACK SEGMENT OTNTRAVEL_RB ONLINE
            /
   Exit SQL*PLUS Session.
3. Download the Oracle8i_user import file. This file contains data to be loaded into the OTNTRAVEL user tablespace in Oracle8i or Oracle9i.
4. On the command prompt, execute the following command :
   $ imp travel/travel@<connect_str> file=otntravel8i.dmp ignore=n full=y log=my.log
   Here connect_str is a valid entry in tnsnames.ora connecting to a travel user in your database. This step takes a few minutes depending on the server configuration.
5. Now to make TRAVEL user Java enabled, execute the following steps :
   Invoke SQL*PLUS with User SYS and Password CHANGE_ON_INSTALL as
   Step a. SQL> Connect sys/change_on_install as SYSDBA
   Step b. SQL> CREATE OR REPLACE JAVA SYSTEM
            /

To Download and install the travel schema into the SYSTEM tablespace:

1. Install Oracle8 or Oracle8i. It may be easiest to select the Typical Installation, since that will automatically install a starter database into which you may import the Travel Schema.
2. Invoke sqlplus as system/manager and create the travel user with the appropriate privileges:
   % sqlplus system/manager
   sqlplus>create user travel identified by travel
   sqlplus>grant all privileges to travel
   sqlplus>exit
3. Download either the Oracle8i for importing into Oracle 8i and Oracle9i databases or Oracle8 for importing into Oracle8 v8.0 database. These files contain data to be loaded into the SYSTEM tablespace in Oracle8 or Oracle8i or Oracle9i.
   
4. From the command line, run the following:
   imp system/manager file=<filename> show=n full=y ignore=n grants=y log=my.log
   where <filename> is the path of either the Oracle8i import file (travel8i.dmp) for importing into Oracle8 i and Oracle9i or the Oracle8 v8.0 import file (travel80.dmp) for importing into Oracle8 v8.0.
5. To run a specific sample, follow the installation instructions for that sample.