Case 8 demonstrates:
Control File
The control file is ULCASE8.CTL. It loads the LINEITEM table with fixed length records, partitioning the data according to shipment date.
Notes:
Table Creation
In order to partition the data, the LINEITEM table is created using four partitions according to the shipment date:
Input Data File
The datafile for this case, ULCASE8.DAT, looks as follows. Each record is 129 characters in length. Five blanks precede each record in the file.
Invoking SQL*Loader
Before invoking SQL*Loader, run the script ULCASE8.SQL as SCOTT/TIGER.
Then invoke SQL*Loader at the command line:
sqlldr scott/tiger control=ulcase8.ctl data=ulcase8.dat
Additional Information: The command sqlldr is a UNIX-specific invocation. To invoke SQL*Loader on your operating system, refer to your Oracle operating system-specific documentation.
Log File
The following shows a portion of the log file:
Table LINEITEM, partition SHIP_Q1, loaded from every logical record.
Insert option in effect for this partition: TRUNCATE
|
|
Oracle 8i Related Tutorials |
|
---|---|
Oracle 10g Tutorial | Oracle 9i Tutorial |
Informatica Tutorial | Oracle 11g Tutorial |
Oracle 8i Related Interview Questions |
|
---|---|
Oracle 10g Interview Questions | Oracle 9i Interview Questions |
Oracle 8i Interview Questions | Informatica Interview Questions |
PL/SQL Interview Questions | Oracle 11g Interview Questions |
SQL Interview Questions | Oracle apps Interview Questions |
Sybase Interview Questions | Oracle Apps ERP Interview Questions |
Oracle 7.3 Interview Questions | Oracle Access Manager Interview Questions |
Oracle Application Framework Interview Questions | Oracle Apps DBA Interview Questions |
Oracle 8i Related Practice Tests |
|
---|---|
Oracle 10g Practice Tests | Oracle 9i Practice Tests |
Oracle 8i Practice Tests | Informatica Practice Tests |
PL/SQL Practice Tests | Oracle 11g Practice Tests |
SQL Practice Tests | Oracle apps Practice Tests |
Sybase Practice Tests | Oracle Apps ERP Practice Tests |
Oracle 7.3 Practice Tests |
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.