Installing sample schema in Oracle 10g R2

Author:

Installing sample schemas(HR,OE,PM etc…) in Oracle 10g R2

1. Get the companion disk for Oracle 10g from oracle.com

2. Unzip and extract the contents on the server

3. Run the Oracle Universal Installer to install the components, choose "Oracle database products"

4. After successfull install,login in the database with SYSDBA privs and run the sample schema scripts located here $ORACLE_HOME/demo/schema

5. To continue ahead , refer to this link

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14198/installation.htm

6. During the installation of the sample schema, it would prompt for
some questions such as for locations of directory for log etc.
    a. Mention the directories on which the Oracle software Owner has write permissions, prefer $ORACLE_HOME
    b. version (turned out to be ‘v3’ for Oracle 10gr2, refer to the
script for this in the sql_script, the script will be available as
‘prefix_v3.sql’)

Leave a Reply

Your email address will not be published.