| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: sqlloader reserved word is column name
Try placing the column name within quotes. For example:
"PARTITION" POSITION (1) INTEGER EXTERNAL, ...
Best regards,
Jonathan Gennick
mailto:jonathan_at_gennick.com * 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: Mike.Petrus2_at_gecapital.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
INET: jonathan_at_gennick.com
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: ListGuru_at_fatcity.com (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). Received on Tue Jun 05 2001 - 13:52:02 CDT
 |
 |