Demo Databases DEMODB and TESTDB

To work through the examples in this Loader Tutorial, you need demo database instances DEMODB and TESTDB, and all demo data in database instance DEMODB.

Database instance DEMODB should be used mainly for the demonstration of the EXPORT commands, and database instance TESTDB for the demonstration of the IMPORT commands.

Prerequisites

Install the database software and tools.

To do so, proceed as described in Installation Manual.

Procedure

Create a demo database instance with the name DEMODB, and one with the name TESTDB.

Load all demo data into the DEMODB database instance when you create this database instance. Do not load the demo data into the TESTDB database instance when you create this database instance.

You can use the Installation Manager or the Database Manager to create a database instance and load all demo data.

?     Installation Manual, Creating the Demo Database Instance DEMODB

Select Load Tutorial Data in the Database Configuration window of the Installation Manger if you want to load all the demo data.

?     Database Manager GUI, Creating a Database Instance: Desktop PC/Laptop

Select Load Tutorial to load all the demo data.

?     Database Administration Tutorial, Creating and Configuring a Database Instance (using the Database Manager CLI)

When you have created the database instance DEMODB, execute the load_tutorial command to load all demo data.

You can load all demo data into the database instance DEMODB at a later stage if you do not load all data when you create the database instance. You can use the Database Manager to load all demo data.

?     Database Manager GUI, Loading Demo Data

?     Database Manager CLI, load_tutorial

Result

Demo databases DEMODB and TESTDB have been created.

Database user MONA has been created in the DEMODB database as a database administrator (DBA) with the password RED. The database administrator MONA can open several database sessions at once (NOT EXCLUSIVE).

The HOTEL demo schema has also been created. The HOTEL demo schema represents a very basic hotel administration system with information on the hotel’s visitors, location, vacancies, room prices, and so on. This information is stored in a series of simply-structured tables. These tables are filled with demo data, and other objects, such as view tables and indexes, have been created.

See also:

Concepts of the Database System, Demo Database, Objects in the HOTEL Schema

You can change the demo data to suit your needs. However, your results may then deviate from the example results given in this tutorial.

This HOTEL demo schema was developed for practice and testing purposes and contains predefined demo data. Do not use the demo data in a production system.

The TESTDB database does not contain any demo data. Some examples require the database user MONA. In this case you can create the database user MONA as follows:

       1.      Log on to the database instance TESTDB as a database system administrator using a suitable tool (such as SQL Studio).

If you copied the default values when you created the database instance TESTDB, the database system administrator has the following user data:
user name: DBADMIN, password: SECRET

       2.      Create the database user MONA with the following SQL statement:

CREATE USER mona PASSWORD red DBA NOT EXCLUSIVE

Some examples require the HOTEL demo schema. In this case you can create the HOTEL schema as follows:

       3.      Log on to the database instance TESTDB as user MONA using a suitable tool (such as SQL Studio).

       4.      Create the HOTEL schema with the following SQL statement:

CREATE SCHEMA hotel