The following procedure has been tested on an RedHat Linux system. Please make necessary modifications for your platform. PART I: Data Load NOTE: Order of execution of these commands is important. (a) Make sure you that Oracle is installed and you are able to execute SQL*Plus and SQL*Loader. shell> which sqlplus sqlldr /opt/oracle/product/10.2.0/db_1/bin/sqlplus /opt/oracle/product/10.2.0/db_1/bin/sqlldr (b) Create Oracle user (e.g. snp), and execute SNP_Tables_102507.sql and SNP_Package_102507.sql to create the user's schema. shell> cd sql shell> sqlplus snp/pass@SID SQL> @SNP_Tables_102507.sql SQL> @SNP_Package_102507.sql SQL> exit; shell> cd .. (c) Load data shell> cd ctl shell> sqlldr userid=snp/pass@SID control=population.ctl shell> sqlldr userid=snp/pass@SID control=technology.ctl shell> sqlldr userid=snp/pass@SID control=omim.ctl shell> sqlldr userid=snp/pass@SID control=snp_omim_map.ctl shell> sqlldr userid=snp/pass@SID control=single_omim_map.ctl shell> sqlldr userid=snp/pass@SID control=double_omim_map.ctl (d) Check that the data was loaded properly. Log on to the database and check the number of rows in each of 6 tables below. For example: shell> sqlplus snp/pass@SID SQL> select count(*) from Population; Commands and table names are NOT case-sensitive. Row counts should be as follows: 1) Population 3 2) Technology 6 3) OMIM 18003 4) SNP_OMIM_Map 187 5) Single_OMIM_Map 905 6) Double_OMIM_Map 396 If there are fewer rows in any of the tables, check the file data/