Oracle SQL Loader Writer

Oracle® SQL Loader files are text files formatted for loading into relational databases. In particular, the format of these files works well with the SQL Loader utility supplied by Oracle for use with Oracle databases.

For more information, see the Column-Aligned Text (CAT) Reader.

Note  This type of file can only be written – it is not possible to read these files.
The Oracle SQL Loader writer does not support spatial data, and it does not create the required table when the ctl file is run.

Oracle SQL Loader Product and System Requirements

Format

FME Platform

Operating System

Reader/Writer

FME Form

FME Flow

FME Flow Hosted

Windows 64-bit

Linux

Mac

Writer

Yes

Yes

Yes

Yes

Yes

Yes

Table Creation

Creating a Table via the CTL File