Record Delimiter Required for Sqlloader?

From: Brian Li <cphdcbl_at_ted.cs.depaul.edu>
Date: 1997/11/15
Message-ID: <64jhs6$kco$1_at_news.depaul.edu>#1/1

Dear netters,

	I have a question on SQLLoader.
	We are currently using Oracle 7.3 on HP UX 10.2 and trying to 

load some data transferred from mainfram. The problem is that we are doing binary transfer and there are no newline inserted at the end of each record. This is fine but it seems that sqlloader can only recognize the first record, thinking the entire file is one big record. So, the loading stops after reading one record. The rest is ignored.

        Is it true that sqlloader expects record delimiter in order to recognize each record? ...even though we provide it full record layout?

        Any info and hint will be appreciated?

        Thanks in advance.

                                                        Brian Received on Sat Nov 15 1997 - 00:00:00 CET