OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » SQLLDR

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

SQLLDR [message #63544]

Thu, 14 October 2004 22:06

puneet
Messages: 76
Registered: August 2002

Member

hi everyone

�I WANT TO LOAD DATA IN A CLOB COLUMN USING� SQLLDR ....

Can Anyone help me plz its urgent

Puneet

�

�

Report message to a moderator

Re: SQLLDR [message #63548 is a reply to message #63544]

Fri, 15 October 2004 03:20

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

Senior Member
Account Moderator

Use a LOBFILE option.
Have a look here
http://www.orafaq.com/faqloadr.htm#LOBS

Report message to a moderator

Re: SQLLDR (urgent) [message #63572 is a reply to message #63548]

Sun, 17 October 2004 21:12

Puneet sachar
Messages: 62
Registered: October 2003

Member

Hi Mashesh,

While loading the file I am getting following error ...

Record 1: Rejected - Error on table IMAGE_TABLE.
ORA-01460: unimplemented or unreasonable conversion requested

Any idea ,,,,?

Report message to a moderator

Re: SQLLDR (urgent) [message #63575 is a reply to message #63572]

Mon, 18 October 2004 03:38

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

Senior Member
Account Moderator

Post the datafile,ctl file, oracle version , sqlldr version and command line you used.

Report message to a moderator

Re: SQLLDR (urgent) [message #63586 is a reply to message #63575]

Mon, 18 October 2004 19:54

Puneet sachar
Messages: 62
Registered: October 2003

Member

Hi Mahesh,

the problem was conversion of number field.
I was going to some article somewhere and it says SQLDDR can create problem in explict conversions...

Anyways Things got sorted out.

Cheers
Puneet

Report message to a moderator

Previous Topic:	Intallation of Oracle Application
Next Topic:	Database link 9i - RDB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 06:28:19 CDT 2024