Oracle7 Server Utilities

Contents Index Home Previous Next

Including Data in the Control File with BEGINDATA

If your data is to be contained in the control file, it is placed at the end of the control specifications. You must place the BEGINDATA keyword before the first data record to separate the data from your data definitions. The syntax is:

BEGINDATA

This keyword is used with the INFILE keyword, described in the next section. Case 1 [*] contains an example.

If you omit BEGINDATA, SQL*Loader tries to interpret your data as control information, and you receive an error message. If the data is in a separate file, reaching the end of the control file signals that control information is complete, and BEGINDATA should not be used.

There should not be any spaces or other characters on the same line after the BEGINDATA clause. Otherwise, the line containing BEGINDATA is interpreted as the first line of data.

Do not put comments after BEGINDATA--they are also interpreted as data.

Contents Index Home Previous Next