Home » RDBMS Server » Server Utilities » Oracle 9i (sql*loader question)
Oracle 9i [message #532837] Fri, 25 November 2011 02:42 Go to next message
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.
Re: Oracle 9i [message #532838 is a reply to message #532837] Fri, 25 November 2011 02:48 Go to previous messageGo to next message
Littlefoot
Messages: 21528
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.
Re: Oracle 9i [message #532848 is a reply to message #532837] Fri, 25 November 2011 03:18 Go to previous messageGo to next message
Michel Cadot
Messages: 66773
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Oracle 9i [message #533042 is a reply to message #532848] Sun, 27 November 2011 15:08 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

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

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


Current Time: Sat Jan 18 00:22:26 CST 2020