Re: how to import text data into oracle database tables?

Oracle has a packet of tools called Oracle enterprise manager. At work, I have it on a PC to acess a database in a SUN station. In that packet there is a tool called data manager. It is a graphical tool. In there, you´ve got the graphical versions of import, export, and loader. The only work you have is to make a parametrization file and store it in disk. Than, give it´s path/name in the loader, as well as the path/name of the data file ...

Stanley Chai wrote in message <7pfhb7$c8k$1_at_violet.singnet.com.sg>...
>I have a text file containing lines of rows. e.g.
>
> customer_name, customer_telephone, customer_addr, ....
>
>What's the simplest way (e.g. using SQL Plus or a command-line program)
>to load the data into a Oracle Database table?
>
>I am running Oracle8i on Windows NT.
>
>Thanks for any clue.
>
>Best Regards,
>Stanley
>
>
>
>
>
Received on Sun Aug 22 1999 - 19:24:09 CEST