Re: sql*loader and stdin?
Date: Sun, 08 Jan 2006 21:37:59 +0100
Message-ID: <dprt78$ch4$00$1_at_news.t-online.com>
[Quoted] Volker Hetzer schrieb:
> DA Morgan wrote:
>
>> Not sure given I don't know your environment. But I would expect that an >> external table can do anything SQL*Loader can do ... as they are >> essentially the same mechanism.
>
> Will try that next week.
> Thanks a lot!
> Volker
[Quoted] To use external tables, data has to be accessible from the server (most
likely, but not tested, whether CIFS share from client mounted by the
server will work).
The differences between sql*loader and external tables are documented at
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/et_concepts.htm#i1012231
Where is also some additional information at
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/et_concepts.htm#sthref1672
<quote>
The access driver runs inside the database server. This is different
from SQL*Loader, which is a client program that sends the data to be
loaded over to the server. This difference has the following implications:
The server must have access to any files to be loaded by the
access driver.
</quote>
Best regards
Maxim Received on Sun Jan 08 2006 - 21:37:59 CET