TABLE

Default: There is no default

Purpose

The TABLE parameter activates SQL*Loader express mode.

Syntax and Description

TABLE=[schema-name.]table-name

If the schema name or table name includes lower case characters, spaces, or other special characters, then the names must be enclosed in double quotation marks and that entire string enclosed within single quotation marks. For example:

TABLE='"hr.Employees"'

Restrictions

  • The TABLE parameter is valid only in SQL*Loader express mode.

Example

The following example loads the table employees in express mode:

> sqlldr hr TABLE=employees