Re: Loading Data from Text file to Oracle Database

vinothkumar <member22879_at_dbforums.com> wrote in message news:<2402055.1042795932_at_dbforums.com>...
> Hi,
> I need to import data from a text file to Oracle 9 database. This is an
> web application in which user may load the file from any location and
> trigger a process to upload the data from the text file. (File location
> and other details about the file are considered).
>
> I would like to know whether it is possible to upload the file at
> the runtime.
> Something similar to bulkinsert in SQL Server.
> (We have also tried SQL Loader of Oracle, SQL Loader in Oracle is a
> Administrator utility)
>
>
> Please help me if you know any solution for this problem.
>
> Thanks and Regards
> -Vinoth Kumar

in 9i you can create external tables around flat files

here is a useful article on the subject
http://www.oracle.com/oramag/oracle/02-jan/index.html?o12advice.html

steve Received on Sat Jan 18 2003 - 06:43:40 CET