Oracle7 Server Utilities
Case Study Files
The distribution media for SQL*Loader contains files for each case:
- control files (for example, ULCASE1.CTL)
- data files (for example, ULCASE2.DAT)
- setup files (for example, ULCASE3.SQL)
If the sample data for the case study is contained in the control file, then there will be no .DAT file for that case. If there are no special setup steps for a case study, there may be no .SQL file for that case. Starting (setup) and ending (cleanup) scripts are denoted by an S or E after the case number. The table below lists the files associated with each case:
CASE
| .CTL
| .DAT
| .SQL
|
1
| x
|
| x
|
2
| x
| x
|
|
3
| x
|
| x
|
4
| x
| x
| x
|
5
| x
| x
| x
|
6
| x
| x
| x
|
7
| x
| x
| x S, E
|
Table 4 - 1. Case Studies and their Related Files
Additional Information: The actual names of the case study files are operating system-dependent. See your Oracle operating system-specific documentation for the exact names.