Re: [q] how to insert on remote DB

artem <webber_at_astral.ntu-kpi.kiev.ua> wrote in news:dkjbil$nau$1_at_news.ntu- kpi.kiev.ua:

> hi there !
>
> have a problem :
>
> 1. I have many files (txt) on the client with particular format, which
> are filled up online
> from time to time and I can't manually turn "att1, att2, ... ,
> attn" into
> "insert into my_remote_table values (att1, att2, ... , attn)".
>
> 2. have a remote oracle-database which must be filled up.
>
> how to ?

Use "sql loader" utility

which is documented at http://tahiti.oracle.com in the Utilities Manaul. Received on Sat Nov 05 2005 - 16:49:25 CST