Re: How to Import/Export Data To-From Oracle 8i Tables

Hi,

Take a look at Chyfo (http://www.ispirer.com/products/) Chyfo can export data from Oracle and any other databases to text files (CSV, TAB delimited, fixed length formats). Chyfo generates DDL statements like CREATE TABLE, CREATE INDEX for Oracle, control files for SQLLoader.
This is command prompt tool that can accept many parameters.

This is easy to use tool. For example, the command: d:>chyfopro /d=ora_base /u=scott /p=tiger /t=dept.% /of=tab will export all tables in the schema DEPT to TAB delimited text files.

Best regards, Dmitry

"Ray Vonhollen" <RVONHOLLEN_at_pacbell.net> wrote in message news:3B0BF715.F7CDB357_at_pacbell.net...
> Vladimir,
>
> Thanks very much for the information. It appears that exp.exe and
> imp.exe are pretty much dependant upon one anothers file format as
> imp.exe needs to use a exp.exe generated file.
>
> I have also found SQL*LOADER via your kindly direction to the Ora Tech
> Network site.
>
> One more question, have you ever run across any 3rd-party utility that
> easily accepts, as its parameters the
> schema,servername,password,tablename and a comma or pipe delimited text
> file?
>
> Thanks again for all your help.
>
> Ray.
>
Received on Sat Jul 21 2001 - 23:43:07 CEST