Re: SQL*Loader

From: Dmitry <support_at_ispirer.com>
Date: Wed, 18 Apr 2001 16:21:07 +0300
Message-ID: <9bk4c3$9mv8h$1@ID-75577.news.dfncis.de>

Hi,

Use SQLLoader to load flat files. To export data to a text file use SQLPlus or 3d party tools such as Chyfo (link below).

Using SQLPlus you can easy export numeric data, but if character data contain commas, double quotes SQLPlus doesn't help you.

Chyfo can export any data including LOBs, generate DDLs and control files for SQLLoader.

Best regards, Dmitry.

--
http://www.ispirer.com/chyfo.html - Tool exports data to CSV flat file,
generates CREATE TABLE, CREATE INDEX scripts for Oracle and control files
for SQL Loader.


"Rodrigo Garces S." <rgarces_at_attglobal.net> wrote in message
news:3adcf0aa_1_at_news1.prserv.net...


> Hi

>

> I  need to import and export flat files from and to Oracle database.

>

> In Sybase I use bcp tool

>

> I need a tool for do it ?

>

> This tool is SQL Loader ?

>

> Is there other way from the SQL PLus ?

>

> Thanks a lot,

>

> Rodrigo

>

>

>

Received on Wed Apr 18 2001 - 08:21:07 CDT