TABLE clause of the
DATA statement enables you to identify tables, fields, and data types. It defines the relationship between records in the data file and tables in the database. The specification of fields and data types is described in later sections.
Among its many functions, the
TABLE clause enables you to specify the table into which you load data. To load multiple tables, you include one
TABLE clause for each table you want to load.
To begin an
TABLE clause, use the keywords
TABLE, followed by the name of the Oracle table that is to receive the data.
The syntax is as follows:
The table must already exist. The table name should be enclosed in double quotation marks if it is the same as any SQL or SQL*Loader reserved keyword, if it contains any special characters, or if it is case sensitive.
INTO TABLE scott."CONSTANT" INTO TABLE scott."Constant" INTO TABLE scott."-CONSTANT"
The user must have
INSERT privileges for the table being loaded. If the table is not in the user's schema, then the user must either use a synonym to reference the table or include the schema name as part of the table name (for example,
scott.emp refers to the table
emp in the
SQL*Loader considers the default schema to be whatever schema is current after your connect to the database finishes executing. This means that the default schema will not necessarily be the one you specified in the connect string, if there are logon triggers present that get executed during connection to a database.