Importing and exporting data

Importing and exporting data You can import and export large amounts of data between files and the database. Instead of having to use INSERT and SELECT statements, you can use system procedures to import data directly from files into tables and to export data from tables into files. bulk import and exportoverview import proceduresoverview export proceduresoverview system proceduresimport and export, overview

The system procedures import and export data in delimited data file format.

Use the export system procedures to write data from a database to one or more files that are stored outside of the database. You can use a procedure to export data from a table into a file or export data from a SELECT statement result into a file.
Use the import system procedures to import data from a file into a table. If the target table already contains data, you can replace or append to the existing data.