SQL*Loader-350 When Username Contains a Period (Doc ID 782683.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.1.0.7
This problem can occur on any platform.

Symptoms

You created a database user with the name containing a period (like "JOHN.SMITH"). Then the load using the following control file:
.
LOAD DATA
INFILE *
TRUNCATE
INTO TABLE "JOHN.SMITH".TAB001
FIELDS TERMINATED BY ";"
TRAILING NULLCOLS
(
   ID,
   TEXT
)
BEGINDATA
1;Text 1
.
raises the error:
.
SQL*Loader-350: Syntax error at line 4.
Expecting "(", found ".".

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms