Index of /~raj/elna-lab-2010/ch3/company/loader

[ICO]NameLast modifiedSizeDescription

[PARENTDIR]Parent Directory   -  
[   ]company-schema.sql 2018-05-17 10:23 827  
[TXT]department.csv 2018-05-17 10:23 199  
[   ]department.ctl 2018-05-17 10:23 186  
[TXT]dependent.csv 2018-05-17 10:23 394  
[   ]dependent.ctl 2018-05-17 10:23 193  
[TXT]dept_locations.csv 2018-05-17 10:23 140  
[   ]dept_locations.ctl 2018-05-17 10:23 160  
[   ]drop.sql 2018-05-17 10:23 134  
[TXT]employee.csv 2018-05-17 10:23 3.2K 
[   ]employee.ctl 2018-05-17 10:23 207  
[   ]load-oracle.sh 2018-05-17 10:23 272  
[TXT]project.csv 2018-05-17 10:23 297  
[   ]project.ctl 2018-05-17 10:23 157  
[TXT]works_on.csv 2018-05-17 10:23 851  
[   ]works_on.ctl 2018-05-17 10:23 145  

There are two files for each table in this directory. For example for the DEPARTMENT table the two files are:
  1. department.csv: contains comma separated data values.
  2. department.ctl: contains Oracle SQL*Loader LOAD command.

Other files found in this directory are:

  1. company-schema.sql: SQL commands to create all tables. Note: To facilitate bulk loading no constraints are enforced.
  2. load-oracle.sh: contains the sqlldr commands to load data for all tables. This script file can be executed from a Unix shell.
  3. drop.sql: SQL commands to drop all tables.