We will require a demo user to perform the loads, a regular tablespace, and some basic privileges for the SQL*Loader demo user. The paths and other particular references are included as mere examples, and to meet the syntax requirements. Actual implementations may differ. During the development of these demonstrations, data from either the HR or SCOTT schemas was used. The next examples use the SYS user to perform administrative tasks, it is only for demonstration purposes, any user with privileges to create a tablespace is enough to setup the environment, and any user who has permission to insert data into a given table is enough to perform the data loading procedure. The paths used and the Oracle SID referred here are just based on a specific demo database used.

connect / as sysdba
create tablespace sqlldrdemo
datafile '/u01/oracle/oradata/beta/sqlldr01.dbf' size 32m
autoextend on next 16m;
create user sqlldrdemo
identified by oracle
default tablespace sqlldrdemo...