Name and object guidelines for the dbload utility
You must follow guidelines for specifying network names and handling simple large objects, indexes, and delimited identifiers when you use the dbload utility.
| Objects | Guideline |
|---|---|
| Network names | If you are on a network, include the database server name and directory path with the database name to specify a database on another database server. |
| Simple large objects | You can load simple large objects with the dbload utility as long as the simple large objects are in text files. |
| Indexes | The presence of indexes greatly affects the speed with which the dbload utility loads data. For best performance, drop any indexes on the tables that receive the data before you run dbload. You can create new indexes after dbload has finished. |
| Delimited identifiers | You can use delimited identifiers with the dbload utility.
The utility detects database objects that are keywords, mixed case,
or have special characters, and places double quotes around them. If your most recent dbload session ended prematurely, specify the starting line number in the command-line syntax to resume loading with the next record in the file. |