Loading the Sample Data Using a Script

After you install the repository using a script, you can run a second script to load the sample data that is used in Oracle Data Miner tutorials.

If you install the repository by using the SQL Developer GUI, then you can install the sample data by checking a check box.

The instDemoData script prepares demo data for an Oracle Data Miner user. The script grants access to the data described. If the SH schema is not present in the database, then the script prepares only the demo data that does not depend on SH.

To install the Oracle Data Miner sample data for a user:

  1. Log in to the database as SYS.

  2. Verify that the SH schema is present in the database.

  3. Run the instDemoData script:

    instDemoData.sql user
    

    For example, if you have set the default search path, then the following statement installs the sample data for the user dmuser1:

    @instDemoData dmuser1
    

To drop the sample data for a user:

  1. Log in to the database as SYS.

  2. Run the dropDemoData script:

    dropDemoData.sql user
    

    For example, if you have set the default search path, then the following statement drops the sample data for the user dmuser1:

    @dropDemoData dmuser1