Function documentationExporting: Loader Commands Locate this document in the navigation structure

 

Loader can process a range of Loader commands and SQL statements, including Loader-specific commands for exporting data.

Prerequisites

Calling the Loader

Opening a Session: Loader Commands

Features

Syntax Syntax

  1. <export_command> ::=
  <export_db_command>
| <export_user_command>
| <export_schema_command>
| <export_table_command>
| <export_columns_command>
End of the code.

With the range of commands provided by Loader you can export a complete database or parts of it, such as user objects, schema objects, data from a table, or a set of column values from a table.

Importing

Importing: Loader Commands

Example

Loader Tutorial, Exporting

More Information

UPDATE COLUMNS Command

Syntax Rules: Sorted Alphabetically

Syntax Rules: Sorted Semantically

Loader Commands and SQL Statements