Create HR schema for ORACLE 10 g

ORACLE 10g is not having the built in hr schema as it was in 9i so we need to build it all over again.
Not to worry here are all the steps to do so.

save all the scripts in oracle/product/10.2.0/db_1/demo/schema/human_resources


download all the scripts from : http://www.mediafire.com/?8n0suo2nim2b2n9

Script Name      Description

hr_analz.sql       Collects statistics on the tables in the schema.

hr_code.sql        Creates procedural objects in the schema.

hr_comnt.sql      Creates comments for each object in the schema.

hr_cre.sql           Creates the HR objects.

hr_dn_c.sql        Adds the distinguished name column used by Oracle Internet Directory to                                     employees and departments tables.

hr_dn_d.sql        Drops the Oracle Internet Directory distinguished name column from employees 

                             departments.

hr_drop.sql        Drops the HR schema and all its objects.

hr_idx.sql          Creates indexes on the HR tables.

hr_main.sql        Main script for the HR schema; calls other scripts.

hr_popul.sql       Populates the objects.

then
        
       
connect to sqlplus from command prompt sys as  sysdba




run the script hr_main as sys dba




to run script type the full path


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