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:
Log in to the database as SYS.
Verify that the SH
schema is present in the database.
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:
Log in to the database as SYS.
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