Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help: Use hex num as RECORD separator in SQL*Loader

Help: Use hex num as RECORD separator in SQL*Loader

From: <hluo_at_my-dejanews.com>
Date: Thu, 01 Oct 1998 19:23:44 GMT
Message-ID: <6v0krv$f8t$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US