Try placing the column name within quotes. For example:
"PARTITION" POSITION (1) INTEGER EXTERNAL,
...
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
Tuesday, June 05, 2001, 1:10:58 PM, you wrote:
PMCG> Can anyone help?
PMCG> I am attempting to load a table, using SQL*Loader, where the table has a
PMCG> column named "PARTITION". Partition is a SQL*Loader reserved word and the
PMCG> load failed with: SQL*Loader-350 Expecting column name found "partition".
PMCG> If anyone has a solution or workaround for this gotcha, I'd like to know
PMCG> what you have done.
PMCG> Thanks very much.
PMCG> Michael L. Petrus
PMCG> GE Auto Warranty Services
PMCG> 7125 W. Jefferson Av. #200
PMCG> Lakewood, CO 80235
PMCG> Database Administrator
PMCG> Phone: (303) 987 4129
PMCG> Fax: (303) 987 4298
PMCG> Email: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
