Oracle 11g: Installing the Oracle 11g Sample Schemas

I wanted to test all SQL scripts without manually creating the tables.  So, I downloaded  the sample schema from here.

2.  You will be receiving a zip file that contains these sql files.

 3.  You can refer to the article (refer to step 1) for steps on how to install the schema samples.  My way is a bit different, I used the 'Oracle SQL Developer'.

Running script through  'Oracle SQL Developer'


1.  If you are using the  'Oracle SQL Developer', first thing that you have to do is to connect either as 'SYS' or 'SYSDBA' that has the system's privileges.

2.  Open the files that you have unzipped.

• If you are accessing the database via "SYSDBA" , simply run the hr_main.sql..all tables will be created automatically.. 
• BUT.if you're accessing through "SYSTEM", run hr_cre.sql (tables) first then hr_popul.sql (data)

 3.  Press F5