Home » RDBMS Server » Server Utilities » TAB delimiter problem
TAB delimiter problem [message #74343] Mon, 22 November 2004 03:05 Go to next message
Jolanda
Messages: 68
Registered: September 2004
Member
Hi you all,

I have a couple of export files, which i import into an Oracle 8 database using sql loader. The files are TAB delimited.
I am getting a lot of unprocessed records in my bad file. However, when i replace the TAB by an another delimeter, for example a "@", then it works fine.

the export files come from a sybase database which has the ISO 8859-1 West European 8-bit (WE8ISO8859P1)
character set. Oracle has the WE8ISO8859P9 characterset.

I ftp the export files from a Windows environment in binary mode to the unix server.

Has anyone experience with this?
Why is TAB not recognized by sqlloader and does another delimeter a better job?

Thanks in advance,

Hakan

Report message to a moderator

Re: TAB delimiter problem [message #74346 is a reply to message #74343] Mon, 22 November 2004 05:41 Go to previous messageGo to next message
croK
Messages: 170
Registered: April 2002
Senior Member
i believe you can try ftp not in binary mode, thus this is an ascii file, try ASCII ftp mode.

Best luck.

Report message to a moderator

Re: TAB delimiter problem [message #74347 is a reply to message #74346] Mon, 22 November 2004 05:43 Go to previous message
hakan
Messages: 1
Registered: November 2004
Junior Member
croK thanks for your reply,

I was thinking about something else, that's why I wrote binary by mistake.
Ofcourse I ftp them in ascii.

So, that is not the reason why it is not working properly!

Report message to a moderator

Previous Topic: SQL*Loader/Cron
Next Topic: Export LOB and XMLtype
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 19:00:24 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.