Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Help: Use hex num as RECORD separator in SQL*Loader
I have some raw data files and I need to load them into the DB using SQL*
Loader. The records in raw data files are separated by 0x02 instead of "\n".
I went through the documenation of SQL* Loader and it seems that I can
specify field separator with great flexibility, but not record separator.
However, because the data files are quite big and will come in on regular
basis, I really want to find a way to avoid preprocessing (i.e. change 0x02
to "\n".) Any suggestion? Thanks! (If reply by email, pls send to
hluo_at_lynx.neu.edu)
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Oct 01 1998 - 14:23:44 CDT
![]() |
![]() |