OraFAQ Forum: Server Utilities » sql loader problem

Home » RDBMS Server » Server Utilities » sql loader problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql loader problem [message #73174]

Thu, 19 February 2004 00:37

Tito Calabrese
Messages: 1
Registered: February 2004

Junior Member

Hi,
I have a problem when I run my ctl file, using sql loader. The problem is that the name of a field is SEQUENCE and this is also a keyword for oracle; how is possible to specify that SEQUENCE in this case is not a keyword but a field name?

Thanks in advance

Best regards.
Tito

Report message to a moderator

Re: sql loader problem [message #73187 is a reply to message #73174]

Thu, 26 February 2004 19:53

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

Try to put SEQUENCE in double quotes - "SEQUENCE".

Nevertheless, it might be best to rename the column's name to something else.

Best regards.

Frank

Report message to a moderator

Re: sql loader problem [message #73188 is a reply to message #73174]

Thu, 26 February 2004 19:59

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

captilize and quote the reserved word.

load data
...
..
into table mytable
...
(
col1,
"SEQUENCE",
col2
)

Report message to a moderator

Previous Topic:	Listner issues
Next Topic:	SQL*Loader-412: More columns specified for table LOAD than the maximum (254)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 05:14:33 CDT 2024