Data Carrier Type

Loader uses a data carrier to physically store the data stream outside the database during export/import. With the syntax element mediumtype_spec you can specify the type of the data carrier for the data stream in import and export commands.

Structure

Syntax Syntax

<mediumtype_spec> ::=
  FILE
| PIPE
| TAPE [<ebid_spec>]

<ebid_spec> ::=
  EBID '<literal>'

End of the code.

Loader differentiates between the data carrier types for the data stream specified in mediumtype_spec. If you do not specify a data carrier type, Loader uses the file system (FILE) as the data carrier for the data stream.

`FILE`	Data carrier for the data stream is the file system.
`PIPE`	Data carrier for the data stream is a pipe.
`TAPE`	(Relevant for `EXPORT DB` only): Data carrier for the data stream is a tape. Communication with the tape uses a third-party backup tool.
`TAPE [<ebid_spec>]`	(Relevant for `IMPORT DB` only): Data carrier for the data stream is a tape. Communication with the tape uses a third-party backup tool. With `EBID '<literal>'`you specify the external backup ID of the data stream to be imported.

Using Third-Party Backup Tools: Data carrier type TAPE is supported when you export/import the entire database and/or the entire database catalog (EXPORT/IMPORT DB). In these cases the third-party backup tool set for the Loader session is used for exporting/importing.

More Information

Exporting and Importing Using Third-Party Backup Tools

EXPORT DB Command

IMPORT DB Command

Data Description