Oracle 10g: Howto reinstall demo schema

The install scripts for the demo schemas are shipped with the oracle 10g installation and are located under:

C:\oracle\product\10.2.0\db_1\demo\schema

You can install all sample schemas using sqlplus and the mksampl.sql file or a single schema located in the subdirectories.

For example here the installation of the HR schema.

C:\Documents and Settings\Administrator>sqlplus connect as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Tue May 20 22:58:55 2008
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> @C:\oracle\product\10.2.0\db_1\demo\schema\human_resources\hr_main.sql

specify password for HR as parameter 1:
Enter value for 1: hr

specify default tablespeace for HR as parameter 2:
Enter value for 2: users

specify temporary tablespace for HR as parameter 3:
Enter value for 3: temp

specify password for SYS as parameter 4:
Enter value for 4: welcome1

specify log path as parameter 5:
Enter value for 5: C:\oracle\product\10.2.0\db_1\RDBMS\log