Tham khảo tài liệu 'oracle 8 database administration volume 2 instruction guide phần 5', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Loading Data Using SQL Loader Log File Contents Header information Global information parameters and file names Table information table and column specifications Data file information records processed Table load information errors and discards Summary statistics 16-12 Copyright Oracle Corporation 1998. All rights reserved. ORACLE The log file is mandatory and the load terminates if the log file cannot be created because of lack of space or permission. The log file contains Header information such as the date of the run and software version number Global information including - Names of all input and output files - Command line arguments Table information such as - Table names - Load conditions and method Field and column information Datafile information showing records rejected and records discarded with reasons only for data files with data errors Oracle8 Database Administration 16-23 Lesson 16 Loading and Reorganizing Data Table load information such as - Number of rows loaded - Number of rows that qualified for loading but were rejected due to data errors - Number of rows that were discarded - Number of rows whose relevant fields were all null Summary Statistics that displays the following data - Amount of space allocated for the array - Load statistics for all data files - Beginning ending time of run - Total elapsed time - Total CPU time including time for all file I O but excluding any CPU time used by background processes 16-24 Oracle8 Database Administration Loading Data Using SQL Loader SQL Loader Other Output Files Bad file - Rejected records - Same format as data files Discard file - Records not satisfying conditions - Same format as data files 16-13 Copyright Oracle Corporation 1998. All rights reserved. ORACLE Bad File The bad file contains records that are rejected during processing due to one of the following reasons Input records have errors such as insufficient number or badly formatted fields Rows could not be inserted for reasons such as .
