The actual load can be done later without the use of SQL*Loader by executing these statements in SQL*Plus. These SQL statements can be edited and customized. When you specify GENERATE_ONLY, all the SQL statements needed to do the load using external tables, as described in the control file, are placed in the SQL*Loader log file.
You may find it helpful to use the EXTERNAL_TABLE= GENERATE_ONLY parameter in SQL*Loader to get the proper access parameters for a given SQL*Loader control file. You must also know enough about SQL to be able to create an external table and perform queries against it. To successfully use the information in these topics, you must have some knowledge of the file format and record format (including character sets and field data types) of the data files on your platform. See the following topics for more information: The information you provide through the access driver ensures that data from the data source is processed so that it matches the definition of the external table. You can use the access parameters to modify the default behavior of the access driver. The ORACLE_LOADER access driver provides a set of access parameters unique to external tables of the type ORACLE_LOADER.
0 kommentar(er)
