OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Oracle 9i (sql*loader question)

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

Oracle 9i [message #532837]

Fri, 25 November 2011 02:42

ravi_n
Messages: 5
Registered: November 2011

Junior Member

Hi Experts,

In a flat file 50000 records are there.
In that some of the records having special charcters.
From that special character record
the remaing records are not loading to oracle tables.
Could you please help me to load the remaing records,
after the record which is having special characters.

The data is loading using sql*loader

Please help me .

Thanks in advance.

Report message to a moderator

Re: Oracle 9i [message #532838 is a reply to message #532837]

Fri, 25 November 2011 02:48

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Are you saying that these characters caused loading session to abort? Or did you reach ERRORS limit? If the latter, increase its value. If the former, it could help if you could post target table description, your control file and several records (a few of them that load correctly, and a few of them that do not load). Maybe there's a solution to your problem.

Report message to a moderator

Re: Oracle 9i [message #532848 is a reply to message #532837]

Fri, 25 November 2011 03:18

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are you unable to find another title than "Oracle 9i"?
A more useful and meaningful one?

Are you unable to post your questions in the correct forum when we already have to move the previous ones on the same subject to the appropriate one and you SHOULD see it?

Regards
Michel

Report message to a moderator

Re: Oracle 9i [message #533042 is a reply to message #532848]

Sun, 27 November 2011 15:08

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

If you share some logs that would be great to understand your problem.

- Babu

Report message to a moderator

Previous Topic:	ora-39183
Next Topic:	Export data ordered and organized!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 21 18:20:02 CST 2025